Find a specific value in a cell

  • Thread starter Thread starter Jason
  • Start date Start date
J

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
 
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?
 
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?
 
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
 
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
 
just another formula that might work for you:

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

(Not case sensitive)
 
Back
Top