Remove "," from txt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a bathc of tect which contains a "space & ,"

E.g. -
MilkyWay, F
Sunnywale, C
Jacksonville, M

and so on

I need to do a batch remove of the comma and space?

Any suggestions?
 
Umm... use SUBSTITUTE as in the solution to your previous post!
Go to formula help if you need to, but the syntax is

SUBSTITUTE(cell,"text you dont want","text you do want")

or, again, use search and replace " ," with ""
 
Use Edit | Replace | Replace All and put in the ", " (no quotes) and leave
the Replace with box empty

Regards

Trevor
 
Back
Top