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

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

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

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)

"Minitman" wrote in message
...
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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


Minitman wrote:
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

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

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

--
Regards,
Tom Ogilvy

"Frank Kabel" wrote in message
...
Hi
one way:
=COUNTIF(A1:A100,"+")0

--
Regards
Frank Kabel
Frankfurt, Germany


Minitman wrote:
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

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

Hey Tom,

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

-Minitman



On Sun, 23 May 2004 09:59:14 -0400, "Tom Ogilvy"
wrote:

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

--
Regards,
Tom Ogilvy

"Frank Kabel" wrote in message
...
Hi
one way:
=COUNTIF(A1:A100,"+")0

--
Regards
Frank Kabel
Frankfurt, Germany


Minitman wrote:
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