View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default 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