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