MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Removing Underscores


Posted by Sam on June 18, 2001 8:24 AM

Does anyone know how to remove underscores from text by using either a macro or a formula. Thanks for your help.
Sam


Posted by Mark W. on June 18, 2001 8:32 AM

=SUBSTITUTE(A1,"_"," ") will replace underscores in
cell A1 with a space.

Posted by Sam on June 18, 2001 9:03 AM

Thank you very much for the help.
Sam