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
|