Find a specific value in a cell

[Jason]

I have a cell that has similar information:

A
1 Tom, Roger, George, Peter

Is it possible to write a formula that would evaluate the
values in the cell and pull out a specific name. For
example, I want the formula to look at cell A1 and then
put "George" in cell B2. Thanks for your help.

Jason

 

[Bob Phillips]

Jason,

I don't get the question. Surely, if you know the name to look for, why not
just stick it in B2. What does searching the cell buy you?

 

[Ken Wright]

Based on what criteria. Just to do as you have asked would be as time consuming as typing George
into B2. Are you looking to parse all the names into separate cells, or perhaps put George into
B2 only if it is found in A1 etc?

 

[Ken Wright]

LOL - Not just me then.

 

[Don P]

Jason,


Possibly what you need is a True/False evaluation of the cell for George?

This will give you "George" if found (True) and a blank if not found
(False). Case sensitive.

=IF(ISERROR(FIND("George",A1)),"","George")


Don Pistulka

 

[Tom Ogilvy]

If you want a case insensitive form, use Search instead of Find. If you
don't want a positive hit if the cell contains Georgey, then you would need
to add more checking.

Regards,
Tom Ogilvy

 

[Dave Peterson]

just another formula that might work for you:

=if(COUNTIF(A1,"*george*"),"george","")

(Not case sensitive)