Formula

[Jen]

I'm trying to create a formula that will look at the text
in column b and if it contains the word "total"
input "company name" in column a. Does anyone have some
advise?

 

[Frank Kabel]

Hi Jen
try in A1:
=IF(ISNUMBER(FIND("total",B1)),"Company Name","")

 

[Guest]

Thank you so much!!!

-----Original Message-----
Hi Jen
try in A1:
=IF(ISNUMBER(FIND("total",B1)),"Company Name","")

--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[Erik]

An easy formula would be

=IF(B1="total","company name",""