| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find if nth char = specific character..
hi, trying to find way to see if 5th character equals the letter A.
know / tried: len( or right( but item tested may have more than 5 characters. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find if nth char = specific character..
Hi,
Try the MID function. =MID(A1,5,1)="A" Cheers Andy nastech wrote: hi, trying to find way to see if 5th character equals the letter A. know / tried: len( or right( but item tested may have more than 5 characters. Thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find if nth char = specific character..
=IF(MID(A1,5,1)="A","yes","no")
-- HTH RP (remove nothere from the email address if mailing direct) "nastech" wrote in message ... hi, trying to find way to see if 5th character equals the letter A. know / tried: len( or right( but item tested may have more than 5 characters. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find if nth char = specific character..
Try working with this:
If the text to test is in Cell A1: B1:=IF(MID(A1,5,1)="A","Yes","No") Does that point you in the right direction? *********** Regards, Ron "nastech" wrote: hi, trying to find way to see if 5th character equals the letter A. know / tried: len( or right( but item tested may have more than 5 characters. Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find if nth char = specific character..
that's great, thanks..
"Bob Phillips" wrote: =IF(MID(A1,5,1)="A","yes","no") -- HTH RP (remove nothere from the email address if mailing direct) "nastech" wrote in message ... hi, trying to find way to see if 5th character equals the letter A. know / tried: len( or right( but item tested may have more than 5 characters. Thanks. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find if nth char = specific character..
that's great, thanks..
"Ron Coderre" wrote: Try working with this: If the text to test is in Cell A1: B1:=IF(MID(A1,5,1)="A","Yes","No") Does that point you in the right direction? *********** Regards, Ron "nastech" wrote: hi, trying to find way to see if 5th character equals the letter A. know / tried: len( or right( but item tested may have more than 5 characters. Thanks. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find if nth char = specific character..
that's great, thanks..
"Andy Pope" wrote: Hi, Try the MID function. =MID(A1,5,1)="A" Cheers Andy nastech wrote: hi, trying to find way to see if 5th character equals the letter A. know / tried: len( or right( but item tested may have more than 5 characters. Thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find a cell starting with a specific letter? | Excel Discussion (Misc queries) | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
| FIND a character | Excel Discussion (Misc queries) | |||
| How Do I Find A Specific Worksheet | Excel Discussion (Misc queries) | |||
| find numbers in a range that add to a specific value | Excel Discussion (Misc queries) | |||
Linear Mode
