Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 698
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,533
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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





  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can i give Space/some other character in between the cell? sumit Excel Worksheet Functions 5 December 9th 08 08:34 AM
Help removing "space" character (question updated) smartgal Excel Discussion (Misc queries) 5 June 30th 08 08:21 PM
Help removing "space" character from imported data smartgal Excel Discussion (Misc queries) 3 June 30th 08 07:38 PM
How do I replace a BEL Character of 7 with a space KBear Excel Discussion (Misc queries) 1 June 6th 06 03:56 PM
NEED HELP-----Removing a space at the end of a string of character FRS Excel Discussion (Misc queries) 7 April 13th 06 03:57 AM


All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"