| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is 3rd character in a cell a space?
Hi Rick,
This may help you. =IF(MID(E26,3,1)=" ","Y","N") HTH Regards, Howard "Rick" wrote in message ... Looking for a way to determine if the 3rd character in a cell is a space. (Dealing with mailing lists; trying to isolate values which are first initial-period- "space" last name. Thank you for your thoughts. Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can i give Space/some other character in between the cell? | Excel Worksheet Functions | |||
| Help removing "space" character (question updated) | Excel Discussion (Misc queries) | |||
| Help removing "space" character from imported data | Excel Discussion (Misc queries) | |||
| How do I replace a BEL Character of 7 with a space | Excel Discussion (Misc queries) | |||
| NEED HELP-----Removing a space at the end of a string of character | Excel Discussion (Misc queries) | |||
Threaded Mode
