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

Closed
john - Mar 23, 2011 at 08:41 AM
rizvisa1 Posts 4478 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 response

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