is 3rd character in a cell a space?
 

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

is 3rd character in a cell a space?
 

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

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

is 3rd character in a cell a space?
 

Hi Rick

See if this can help:

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

Regards,
Per

"Rick" skrev i meddelelsen
...
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

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

is 3rd character in a cell a space?
 

On Dec 21, 1:18*pm, "Per Jessen" wrote:
Hi Rick

See if this can help:

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

Regards,
Per

"Rick" skrev i ...



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- Hide quoted text -

- Show quoted text -

Ya'll are great!
Rick