is 3rd character in a cell a space?
This will return either TRUE or FALSE:
=MID(A1,3,1)=CHAR(32)
CHAR(32) is the standard space character.
--
Biff
Microsoft Excel MVP
"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
|