Convert Text (number and text) into date

[spinelli victor]

[TABLE="width: 113"]
<colgroup><col></colgroup><tbody>[TR]
[TD]05August2011[/TD]
[/TR]
[TR]
[TD]28April2011[/TD]
[/TR]
[TR]
[TD]23February2010[/TD]
[/TR]
[TR]
[TD]16June2011[/TD]
[/TR]
[TR]
[TD]17October2011[/TD]
[/TR]
[TR]
[TD]10November2012[/TD]
[/TR]
[TR]
[TD]05September2012[/TD]
[/TR]
</tbody>[/TABLE]

I have a list of text on this format. How can i tranform it into date. I tried to seperate them but i'm blocked, i don't know how to convert text month non listed into date.

Any ideas ?

 

[Saba Sabaratnam]

Hi

If the date is in the above text format, use the following steps to convert it to date:

Type 1 (one)

Copy it

Multiply the above text dates by it using Multiply under Operation on Paste Special dialog box

Let me know if it works.

Saba

 

[spinelli victor]

Thanks

 

[Peter_SSs]

Another option you could try ..
Select the column -> Data ribbon tab -> Text to Columns -> Finish