convert text to date

I have text "September" in cell A1 and "2011" in A2. How do I convert these text values into a date format Sep-2011?
teaoneAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sanofi-aventisConnect With a Mentor Commented:
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
 
nscohCommented:
Assuming you want this converted and placed into A3.  In cell A3 enter:

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

0
 
barry houdiniCommented:
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
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.