Identify if a cell contains a numerical string

[Pierre]

Have a long list of identifiers:

E6A3289A
F9DB1200G5W
KRQ7356VQ
G1200GUWY87

In a helper column, we need to identify (true or false is ok) if the
value in the first column contains the string 1200.
It may appear anywhere in the cell value; it is not consistently found
after or before a given number of other characters within that cell.

Extra points if it can be done within the result fields in a pivot
table. (IOW, filter for the 1200 on the drag and drop page.)
Ideas?

Pierre

 

[reitanospa1]

Have a long list of identifiers:

E6A3289A
F9DB1200G5W
KRQ7356VQ
G1200GUWY87

In a helper column, we need to identify (true or false is ok) if the
value in the first column contains the string 1200.
It may appear anywhere in the cell value; it is not consistently found
after or before a given number of other characters within that cell.

Extra points if it can be done within the result fields in a pivot
table. (IOW, filter for the 1200 on the drag and drop page.)
Ideas?

Pierre

You could try the FIND function:
=IF(ISERROR(FIND("1200",E14)),"","Found")

 

[Ron Rosenfeld]

Have a long list of identifiers:

E6A3289A
F9DB1200G5W
KRQ7356VQ
G1200GUWY87

In a helper column, we need to identify (true or false is ok) if the
value in the first column contains the string 1200.

Assuming data is in A1:An

=COUNTIF(A1,"*1200*")>0

It may appear anywhere in the cell value; it is not consistently found
after or before a given number of other characters within that cell.

--ron

 

[Pierre]

Assuming data is in A1:An

=COUNTIF(A1,"*1200*")>0


--ron

Thanks to both of you. Both work fine.

Pierre