Convert Text (number and text) into date

spinelli victor

New Member
Joined
Mar 17, 2018
Messages
2
05August2011
28April2011
23February2010
16June2011
17October2011
10November2012
05September2012

<colgroup><col></colgroup><tbody>
</tbody>

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

Board Regular
Joined
May 26, 2018
Messages
97
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
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
42,320
Office Version
365
Platform
Windows
Another option you could try ..
Select the column -> Data ribbon tab -> Text to Columns -> Finish
 

Forum statistics

Threads
1,082,588
Messages
5,366,490
Members
400,895
Latest member
shumcal

Some videos you may like

This Week's Hot Topics

Top