is 3rd character in a cell a space?

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
 
L

L. Howard Kittle

Hi Rick,

This may help you.

=IF(MID(E26,3,1)=" ","Y","N")

HTH
Regards,
Howard
 
P

Per Jessen

Hi Rick

See if this can help:

=If(Mid(A1,3,1)=" ","Space","No Space")

Regards,
Per
 
T

T. Valko

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

Similar Threads

Help finding the last space in a cell 2
Test to see if cell contains a space? 3
I need to copy half of the info in a cell... 3
Remove non-space spaces? 3
Inserting a hyphen after the 3rd character 3
Removing Space 7
Truncating a cell entry to the last full word 4
Double space - period shortcut? 2

Top