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

Closed
john - 23 Mar 2011 à 08:41
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 23 Mar 2011 à 10:55
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

Related:

1 response

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