| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If Character #8 = C
I am trying to take a look at a character nad say if the 8th cahracter is =
to C then how woudl I do it? This is what I have but it is not correct. =IF(D2 ="???????C?","True","False") |
|
#2
|
|||
|
|||
|
Wes,
Use the MID function. E.g., =IF(MID(D2,8,1)="C","True","False") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Wes Paul" wrote in message ... I am trying to take a look at a character nad say if the 8th cahracter is = to C then how woudl I do it? This is what I have but it is not correct. =IF(D2 ="???????C?","True","False") |
|
#3
|
|||
|
|||
|
Hi
=(MID(D2,8,1)="C") Arvi Laanemets "Wes Paul" wrote in message ... I am trying to take a look at a character nad say if the 8th cahracter is = to C then how woudl I do it? This is what I have but it is not correct. =IF(D2 ="???????C?","True","False") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND a character | Excel Discussion (Misc queries) | |||
| How can I combine multiple characters into a single character? | Excel Discussion (Misc queries) | |||
| Searching a cell for a certain character. | Excel Worksheet Functions | |||
| Removing ' character from cells | Excel Discussion (Misc queries) | |||
| Test for Single Character That is in an Array | Excel Worksheet Functions | |||
Linear Mode
