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?

[Tom Ogilvy]

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.

--
Regards,
Tom Ogilvy


"ruchie" wrote:

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

[ruchie]

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