Re: Left() Need the equivalent of this
- From: Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
- Date: Wed, 03 Dec 2008 20:40:06 -0500
On Wed, 3 Dec 2008 20:15:56 -0500, "Presto" <presto__NOSPAM@xxxxxxxxxxxxx>
wrote:
OK, I'm stuck again.
I was trying to use the same logic for MID, to get everything AFTER the /
but it's not working. I only get the / as a result.
I'm using : =IF(E3="", "", MID(E3,FIND("/", E3),1))
=FIND("/",E3) will result in the position of the slash - I understand that
....
Whats wrong with this picture?
You are only returning 1 character.
Look at HELP for the MID function, or check out the prompts as you enter the
formula:
Try:
=IF(E3="", "", MID(E3,FIND("/", E3)+1,255))
The +1 tells the MID function to start returning characters at the position
that is 1 after the "/". The 255 needs to be some value greater than the
length of the rest of the string.
--ron
.
- References:
- Left() Need the equivalent of this
- From: Presto
- RE: Left() Need the equivalent of this
- From: Mike H
- Re: Left() Need the equivalent of this
- From: Presto
- Re: Left() Need the equivalent of this
- From: Presto
- Left() Need the equivalent of this
- Prev by Date: RE: Macro to reset Validation box
- Next by Date: Re: wait for data to be stable
- Previous by thread: Re: Left() Need the equivalent of this
- Next by thread: wait for data to be stable
- Index(es):
Relevant Pages
|
