Creating a Macro to Delete Commas

  • Thread starter Thread starter rontap
  • Start date Start date
R

rontap

I have an excel file that the size will varry. I need a macro that will
check all the fields for a comma. If there is one I would like to get
rid of it. Does anyone have any idea how to do this? I have no idea and
I have been assigned this task.

Help
 
No macro required.

ctrl-H for find/replace. find , replace nothing (leave the
replace field blank). You can of course record that within
a macro if you wish.

Drabbacs
 
Make sure this is what you want and start with a copy of
the original.

Select the data area then choose Edit->Replace. In
the "Find what:" put your comma and then click on the
Replace All button. When you have the steps down exactly,
you can record a macro (like running a VCR - record, stop,
play) and then do it whenever you wish.

Excel Support Technician
www.canhelpyou.com
 
Back
Top