View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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