View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default macro that finds text and keeps only part of it

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.