functions

[mort1703]

Hi

I am looking for a way using an excel function, to search a cell for a specific character and return a true or false.
the cell location starts in column A3 and could be any number of rows.
not all cells in column A will have a match for the character requested.
the character requested could be anywhere in the cell.

Thanks

 

[Toadstool]

Hi Mort1703,

It's not clear if you want one response or each row checked so E3 checks the whole column, column H checks for a non case sensitive match and column I case sensitive:

Mort1703.xlsx
	D	E	F	G	H	I
1	Search for:	N		Text	Not Case Sensitive	Case Senstitive
2				Lorem ipsum dolor sit amet, consectetur adipiscing elit.	TRUE	FALSE
3	Anywhere=	TRUE		Vivamus at nisi non erat dapibus accumsan.	TRUE	FALSE
4				Fusce nec urna eu lacus aliquam eleifend quis eu tellus.	TRUE	FALSE
5				Nullam sed dui sit amet eros egestas egestas.	TRUE	TRUE
6				Vivamus. Nic elit eget risus iaculis.	TRUE	TRUE
7				Proin faucibus non felis.	TRUE	FALSE
8				Etiam tincidunt lacus id bibendum mattis.	TRUE	FALSE
9				Non sit amet urna nec dolor lobortis auctor.	TRUE	TRUE
10				Quisque scelerisque massa quis augue rutrum custard.	FALSE	FALSE
11				Nunc tincidunt enim non interdum hendrerit.	TRUE	TRUE
12				Sed ante maximus, cursus nisl sed, blandit ligula.	TRUE	FALSE
13				Vitae ipsum sec ipsum imperdiet.	FALSE	FALSE
Sheet1

Cell Formulas
Range	Formula
H2:H13	H2	=ISNUMBER(SEARCH($E$1,G2))
I2:I13	I2	=ISNUMBER(FIND($E$1,G2))
E3	E3	=NOT(ISNA((MATCH("*"&$E$1&"*",$G$2:$G$9999,0))))