Remove "," from txt

[Prasad Gopinath]

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?

 

[Dave R.]

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 ""

 

[Trevor Shuttleworth]

Use Edit | Replace | Replace All and put in the ", " (no quotes) and leave
the Replace with box empty

Regards

Trevor