Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can i give Space/some other character in between the cell? | Excel Worksheet Functions | |||
Help removing "space" character (question updated) | Excel Discussion (Misc queries) | |||
Help removing "space" character from imported data | Excel Discussion (Misc queries) | |||
How do I replace a BEL Character of 7 with a space | Excel Discussion (Misc queries) | |||
NEED HELP-----Removing a space at the end of a string of character | Excel Discussion (Misc queries) |