is 3rd character in a cell a space?

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

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
 
This will return either TRUE or FALSE:

=MID(A1,3,1)=CHAR(32)

CHAR(32) is the standard space character.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top