<div>
Assuming you want this converted and placed into A3. &nbsp;In cell A3 enter:<br />
<br />
=DATEVALUE(A1 &amp;&nbsp;&quot;1, &quot;&nbsp;&amp; A2)<br />
<br />

</div>


Assuming you want this converted and placed into A3.  In cell A3 enter:

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



<div>
If you use this formula in A3 it'll give you a date (1st of that month)<br />
<br />
=A1&amp;A2<br />
<br />
You can then format any way you want.<br />
<br />
or if you want text<br />
<br />
=TEXT(A1&amp;A2,&quot;mmm-yyyy&quot;)<br />
<br />
regards, barry
</div>


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

<div>
<div class="content wysiwyg-content">
I have text &quot;September&quot; in cell A1 and &quot;2011&quot; in A2. How do I convert these text values into a date format Sep-2011?
</div>
</div>


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

convert text to date

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.