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

Hi,

I would use formulas over macro / programs. Left() & Right() formula can
separate say the left three characters or the right four character out of you
code string. Then an If Statement can compare those formulas to what you are
looking for. Or a VLookup / HLookup can locate the codes and then pull
information that is related to these codes from adjacent cells.

Type in "=left(" and hit the insert function button "fx" to the left of the
Formula Bar (where you type info in Excel). You can use the function button
for help with the "=VLookup(" too.

You end result will probable a combination of all the above listed formula,
but for now figure out what the do individually and you will be a step closer
to knowing your answer.

If you are dealing with values not text then you may need a SumIf instead of
the VLookup.

Shawn


" wrote:

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