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
|