find text within a string

Rasberry

Board Regular
Joined
Aug 11, 2002
Messages
158
I am writing a simple logical formula--something to accomplish this:

If cell A10 includes the word "Total", then perform calculation, if not, do nothing.

What function finds text string within a string, then can perform another task?

Thanks,

Rasberry
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
=IF(FIND("Total",A10),"Found","Not Found")

HTH
Cal
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Search() or Find() depending on if you want to match case or not.

=Search("Total",A10) if case sensitivity is not important.

=Find("Total",A10) if case sensitivity is important

Insert either into your IF() formula
 

Watch MrExcel Video

Forum statistics

Threads
1,114,407
Messages
5,547,771
Members
410,811
Latest member
adustin42
Top