Excel Macro to convert 'AAA-####' to 'AAA ###

Closed
john - Mar 23, 2011 at 08:41 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Mar 23, 2011 at 10:55 AM
Hello,

I'm working on a project and need a macros that will look at all the cells in a column and covert the value in the cells from AAA-#### to AAA ####. Thanks

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Mar 23, 2011 at 10:55 AM
would not simple find and replace work here ?
0