Text strings

[Pinda]

I have lines and lines of this data in a spreadsheet@

@vZ(
PrintSMPCT-FS01
úO/ýCFå;+|111Priority
Practice Analysis.xlsSarahTHP Color 4600
FalklandIP_62.130.88.322297110
d
LfLe¹f–?f–?

Each line of data is within 1 cell. I need to
create a lookup that returns all the rows with '4600'
contained within the text. The trouble is that the 4600
can be anywhere within
the text string, so i cannot use functions such as left or
mid.

Any ideas?
Thanks in advanvce.

 

[Paul]

I have lines and lines of this data in a spreadsheet@

@vZ(
PrintSMPCT-FS01
úO /ýCFå;+|111Priority
Practice Analysis.xlsSarahTHP Color 4600
FalklandIP_62.130.88.322297110
d
LfLe¹f–?f–?

Each line of data is within 1 cell. I need to
create a lookup that returns all the rows with '4600'
contained within the text. The trouble is that the 4600
can be anywhere within
the text string, so i cannot use functions such as left or
mid.

Any ideas?
Thanks in advanvce.


=FIND("4600",A1)
will return a number (the character position in the text string) if "4600"
is found in A1 and an error if not. So
=ISNUMBER(FIND("4600",A1))
will be TRUE if "4600" is found. You could use this to identify the rows.

A lookup will return data from only one row, not 'all the rows', so I'm not
sure what you mean here.