| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any way to check for duplicate character patterns in a cell? | Excel Discussion (Misc queries) | |||
| How do I evaluate whether a character is present in a cell? | Excel Worksheet Functions | |||
| Spell check / character cell limit | Excel Discussion (Misc queries) | |||
| formula to check Cell value within specific character | Excel Discussion (Misc queries) | |||
| Display characters present after a specific character | Excel Discussion (Misc queries) | |||
![Minitman[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
