View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] birdbyte@gmail.com is offline
external usenet poster
 
Posts: 1
Default Non-programmer needs help with search function

The cells in in my spreadsheet contain a string like this:
AAA#####.##. I need to search the AA portion and the .## portion of
the string for any results where both are true. Ultimately, I'd like
to search for multiple .## entries (AAA and .01 or .02 or .03...).

I've used the Find/Replace function to find all AAA#####.01 entries,
but how do I print it (or export it to another worksheet)? And/or how
can I get it to search for and return records for all the applicable
decimals?

Thanks for any help,
Tim