How Do I Check To See Id A Character Is Present In A Cell

M

Minitman

Greetings

This is an easy one, I just cant remember what the command is!!!

I need to see if a certain character is present in a range of cells.
I will be using Conditional Formatting on the cells in question. The
character is the plus sign (+).

Any help would be appreciated.

TIA

-Minitman
 
B

Bob Phillips

If you want the formula for CF, try

=NOT(ISERROR(FIND("+",A1)))

bu this won't work if the + is in a formula

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
T

Tom Ogilvy

=COUNTIF(A1:A100,"*+*")>0

might be a suggested expansion (if there will be more text than just the
plus sign)

This assumes you are looking at the displayed text and not the formula.
 
M

Minitman

Hey Tom,

Thank you all for the assistance, that is just what I was looking for.

-Minitman
 
Top