search and delete commas

[ruchie]

in the excel file im working on, i need to search and delete all the
commas occuring anywhere within the worksheet. how should i go about it
using a macro?

 

[Guest]

Turn on the macro recorder and then do Edit=>Replace and enter the comma in
the find what and leave replace with blank.

Then turn off the macro recorder. Look at the recorded code.

 

[ruchie]

u know what Tom.. u solved huuuge amount of problems for me by this
suggestion! thanks!!!