| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
first space from the right
Hi all, I'm trying to find the 1st space from the right of a sow of strings
of different lengths. for e.g. a row might be " mr smith 2 arcadia la". thanks again all -- delmac |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
first space from the right
=FIND(CHAR(1),SUBSTITUTE(E1," ",CHAR(1),LEN(E1)-LEN(SUBSTITUTE(E1," ",""))))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "delmac" wrote in message ... Hi all, I'm trying to find the 1st space from the right of a sow of strings of different lengths. for e.g. a row might be " mr smith 2 arcadia la". thanks again all -- delmac |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
first space from the right
didn't work I'm afraid.
-- delmac "Bob Phillips" wrote: =FIND(CHAR(1),SUBSTITUTE(E1," ",CHAR(1),LEN(E1)-LEN(SUBSTITUTE(E1," ","")))) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "delmac" wrote in message ... Hi all, I'm trying to find the 1st space from the right of a sow of strings of different lengths. for e.g. a row might be " mr smith 2 arcadia la". thanks again all -- delmac |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
first space from the right
Well I just put your example into E1, added the formula, and it returned 19.
Looks like it worked to me. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "delmac" wrote in message ... didn't work I'm afraid. -- delmac "Bob Phillips" wrote: =FIND(CHAR(1),SUBSTITUTE(E1," ",CHAR(1),LEN(E1)-LEN(SUBSTITUTE(E1," ","")))) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "delmac" wrote in message ... Hi all, I'm trying to find the 1st space from the right of a sow of strings of different lengths. for e.g. a row might be " mr smith 2 arcadia la". thanks again all -- delmac |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
first space from the right
thnaks very much Bob, it did work firts time, Iwas just to stupid to actually
copy it into the correct cell. regards -- delmac "Bob Phillips" wrote: Well I just put your example into E1, added the formula, and it returned 19. Looks like it worked to me. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "delmac" wrote in message ... didn't work I'm afraid. -- delmac "Bob Phillips" wrote: =FIND(CHAR(1),SUBSTITUTE(E1," ",CHAR(1),LEN(E1)-LEN(SUBSTITUTE(E1," ","")))) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "delmac" wrote in message ... Hi all, I'm trying to find the 1st space from the right of a sow of strings of different lengths. for e.g. a row might be " mr smith 2 arcadia la". thanks again all -- delmac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Space-bar -- "recurring" instead of <space | Excel Discussion (Misc queries) | |||
| Space removal - a first name,space last name | Excel Discussion (Misc queries) | |||
| Can I automatically add space after ea. row ("Space After" in Word | Excel Discussion (Misc queries) | |||
| formula that will go up one space if no value in specified space | Excel Worksheet Functions | |||
| Paper Space / Model Space ? | Excel Discussion (Misc queries) | |||
Linear Mode
