Excel - search string inside text 2

[jhogie]

Firstly, I must admit that I am embarrased that I need to ask this question.

I have a column where each cell has a different text. In the adjacent column I would like to indicate if the column contains a specific string.

ie. Does column 'A' contain the string 'ic'
A B
Rick Y
Tim N
Mickey Y
Jeff N

I am currently using the following function in the column 'B'

=If(A1="*ic*", "Y", "N")

I know how to do this using a module, however I would like to simply enter the function in the cell. Any help would be much appreaciated.

Thanks in advance.

- Jeff

 

[GlennUK]

Using

=NOT(ISERROR(FIND("ic",A1)))

will return TRUE or FALSE as a result. If you really want Y and N then use:

=IF(ISERROR(FIND("ic",A1),"N","Y")

If you want the searching not to be case sensitive use SEARCH instead of FIND.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

Hi,
[rr]
=IF(ISNUMBER(FIND("ic",A1)),"Y","N")
[/tt]

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

[tt]Looks like you monospaced your brain Skip.[/tt]

Gerry

 

[SkipVought]

Is this a mono e mono challenge??? ;-)

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}