Solved

convert text to date

Posted on 2011-09-22
3
178 Views
Last Modified: 2012-05-12
I have text "September" in cell A1 and "2011" in A2. How do I convert these text values into a date format Sep-2011?
0
Comment
Question by:teaone
3 Comments
 
LVL 2

Accepted Solution

by:
sanofi-aventis earned 250 total points
ID: 36582842
Use the Function DateValue()

=DateValue( A1& " " & B1) And format the Cell with the date format as  you like. Or rap it in a Text function
=Text(DateValue(A1&" "&B1), "Mmm-YYYY")
0
 

Expert Comment

by:nscoh
ID: 36582857
Assuming you want this converted and placed into A3.  In cell A3 enter:

=DATEVALUE(A1 & "1, " & A2)

0
 
LVL 50

Expert Comment

by:barry houdini
ID: 36582891
If you use this formula in A3 it'll give you a date (1st of that month)

=A1&A2

You can then format any way you want.

or if you want text

=TEXT(A1&A2,"mmm-yyyy")

regards, barry
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

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…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

820 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