String within a string test?

roscoe

Well-known Member
Joined
Jun 4, 2002
Messages
1,016
Call me stupid, but I can't figure out to develop a simple test to see if a 1 character string exists within another string. I have been trying to use the FIND command but it generates error messsages when the string is not included and they are killing me.

Any help on a simple test that results in TRUE or FALSE?

Thanks!
Merry Christmas!
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Try a variation of this

=ISNUMBER(FIND("a",A1))

FIND is case-sensitive, switch to SEARCH if you don't want it to be case-sensitive
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,504
Members
412,672
Latest member
vitaminshop20
Top