dubmartian
New Member
- Joined
- Dec 16, 2016
- Messages
- 20
Hi all,
Ive searched a few posts related to removing commas and Ive tried to adapt the answers to my situation with no luck so I am biting the bullet and adding to the forum fodder. Here is my situation.
I have about 6k rows of text where there are single comas separating values and at some point double commas. ( this happened when I replaced commas for carriage returns in the original data).
The double commas are what I would like to remove. They do not occur at the same positions through all 6k records.
If I do a ctrl F to find a comma it doesnt return any results although there are at least 10 commas per line. This also does not work for the double commas.
What I was able to do was remove the trailing comma left at the end of each record so I know they are real
So in general I would like to search for every instance of ",," and replace with just ","
Things that did not work for me so far:
=SUBSTITUTE(a1,",,",",")
CTRL H Find ,, and replace ,
Thanks in advance.
<tbody>
</tbody>
Ive searched a few posts related to removing commas and Ive tried to adapt the answers to my situation with no luck so I am biting the bullet and adding to the forum fodder. Here is my situation.
I have about 6k rows of text where there are single comas separating values and at some point double commas. ( this happened when I replaced commas for carriage returns in the original data).
The double commas are what I would like to remove. They do not occur at the same positions through all 6k records.
If I do a ctrl F to find a comma it doesnt return any results although there are at least 10 commas per line. This also does not work for the double commas.
What I was able to do was remove the trailing comma left at the end of each record so I know they are real
So in general I would like to search for every instance of ",," and replace with just ","
Things that did not work for me so far:
=SUBSTITUTE(a1,",,",",")
CTRL H Find ,, and replace ,
Thanks in advance.
10250T - Accessories , 10250ED1065-2 , UPC:782113718811 , , Height: X , Length: X , Width: X , Manufacturer Warranties: , 1 year , , Type: 10250T , Size: 30 mm , Product Category: Adapter for standard and master indicating light |
<tbody>
</tbody>
Last edited: