Solved: Delete , in column A.

[Marcster]

Hi people,

In column A I have data as follows:

abc, ltd
something,
12, 345

I need a procedure to change the data so it displays as:

abc ltd
something
12 345

The procedure should find and delete the ,
if found in column A. The location of , will differ and
sometimes the cell will not have a , in it at all.
Also the length of column A will vary too.

Thanks,

Marcster.

[Killian]

So you want to find "," in column A and replace with "" ?
Columns("A:A").Replace What:=",", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

[Marcster]

Hi Killian,
I want to find "," in column A and replace with " "

When I run the code I get:
Run-time error '1004':
Application-defined or object-defined error

Any ideas, thanks,

Marcster.

[Killian]

Well I don't,
at least until I tried it in Excel 97, then I did
so I tried thisColumns("A:A").Replace What:=",", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=Falsethen I didn't again
Which version are you running?

[Marcster]

Thanks Killian,

Works great. I'm using Excel 2000.

Marcster.