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
pdvsaProject financeAsked:
Who is Participating?
 
käµfm³d 👽Connect With a Mentor Commented:
Perhaps:

=RIGHT(B1, 8)

Open in new window

0
 
Saqib Husain, SyedEngineerCommented:
=mid(b21,28,8)
0
 
käµfm³d 👽Commented:
P.S.

* Assumes a 4-digit year and 3-character month abbreviation.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
Saqib Husain, SyedEngineerCommented:
Sorry change that to

=mid(b21,20,8)
0
 
pdvsaProject financeAuthor Commented:
very nice.  thank you
0
 
pdvsaProject financeAuthor Commented:
ssaqibh:  I see that you changed the answer now.  I think RIGHT is a little easier at least for me...thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.