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

[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

 

[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)

 

[Frank Kabel]

Hi
one way:
=COUNTIF(A1:A100,"+")>0

 

[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.

 

[Minitman]

Hey Tom,

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

-Minitman