is 3rd character in a cell a space?
Try this:
=IF(MID(A1,3,1)=" ","Yes","No")
Hope this helps.
Pete
On Dec 21, 7:06*pm, Rick wrote:
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
|