You don't need a macro for this - you can use a wildcard Find/Replace, where:
Find = \[A[!1]*\]
Replace = nothing
This will delete all of the [A# text] where # is any number other than 1.

Cross-posted at: http://stackoverflow.com/questions/2...ets-and-delete#


For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for the reply macropad. I want to use a macro because I want to automate a process at work, and I need to make it easy for the older guys to use. Pretty much I want the final version to only need a model number as the input.

Thanks again.