pdvsa
asked on
Left
Experts,
I am trying to extract Jun 2012 from the following:
Sum of Available In Jun 2012
I thought I could do this but I get a #value:
=LEFT(B21,28)-LEFT(B21,20)
How can I extract Jun 2012? Maybe there is a better way. thank you
I am trying to extract Jun 2012 from the following:
Sum of Available In Jun 2012
I thought I could do this but I get a #value:
=LEFT(B21,28)-LEFT(B21,20)
How can I extract Jun 2012? Maybe there is a better way. thank you
=mid(b21,28,8)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
P.S.
* Assumes a 4-digit year and 3-character month abbreviation.
* Assumes a 4-digit year and 3-character month abbreviation.
Sorry change that to
=mid(b21,20,8)
=mid(b21,20,8)
ASKER
very nice. thank you
ASKER
ssaqibh: I see that you changed the answer now. I think RIGHT is a little easier at least for me...thank you