Left

pdvsa
pdvsa used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
=mid(b21,28,8)
Glanced up at my screen and thought I had coded the Matrix...  Turns out, I just fell asleep on the keyboard.
Most Valuable Expert 2011
Top Expert 2015
Commented:
Perhaps:

=RIGHT(B1, 8)

Open in new window

ǩa̹̼͍̓̂ͪͤͭ̓u͈̳̟͕̬ͩ͂̌͌̾̀ͪf̭̤͉̅̋͛͂̓͛̈m̩̘̱̃e͙̳͊̑̂ͦ̌ͯ̚d͋̋ͧ̑ͯ͛̉Glanced up at my screen and thought I had coded the Matrix...  Turns out, I just fell asleep on the keyboard.
Most Valuable Expert 2011
Top Expert 2015

Commented:
P.S.

* Assumes a 4-digit year and 3-character month abbreviation.
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Sorry change that to

=mid(b21,20,8)
pdvsaProject finance

Author

Commented:
very nice.  thank you
pdvsaProject finance

Author

Commented:
ssaqibh:  I see that you changed the answer now.  I think RIGHT is a little easier at least for me...thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial