Marcster
10-28-2005, 06:18 AM
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.
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.