Find and replace works great for finding the text but I need more. I dont
want to have to manually delete things. I was hoping to use something that
would delete the first 10 characters and keep the rest ( as an example ).
can this be done with wildcards or something? Thanks again.

"Anne Troy" wrote:

Find and replace won't work?
************
Anne Troy
www.OfficeArticles.com

"john mcmichael" wrote in message
...
I have a spreadsheet that I'm trying to run a seach on to find a specific
sting of test. I can run the search but, now I want to ake it one step
further. Is it possible to search for a sting of text and then delete
part
of the sting and leave some of the text? Then is it possible to do this a
macro? Thanks for the help.