Solved

Left

Posted on 2012-03-29
6
256 Views
Last Modified: 2012-03-29
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
0
Comment
Question by:pdvsa
  • 2
  • 2
  • 2
6 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 37784252
=mid(b21,28,8)
0
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 500 total points
ID: 37784254
Perhaps:

=RIGHT(B1, 8)

Open in new window

0
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 37784260
P.S.

* Assumes a 4-digit year and 3-character month abbreviation.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 37784261
Sorry change that to

=mid(b21,20,8)
0
 

Author Closing Comment

by:pdvsa
ID: 37784286
very nice.  thank you
0
 

Author Comment

by:pdvsa
ID: 37784289
ssaqibh:  I see that you changed the answer now.  I think RIGHT is a little easier at least for me...thank you
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Manipulation Macro 28 36
macro for finding text and replacing 7 43
macro for same location path 2 19
Automating Excel Weekly Report 13 46
INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now