Split Date

[Elton Law]

Dear Expert,
Have used an OCR software to extract data from a PDF file.
The outcome can be as follows:

1Jan2009
12Jan2009
16Feb2009
19 Feb2009
3 Jul 2009
14Jul 2009

How can I make it split into date, month and year please ?

That is ...
All in this kind of format ....

01 Jan 2009
12 Jan 2009
16 Feb 2009
19 Feb 2009
03 Jul 2009
14 Jul 2009

Thanks and regards,

 

[Jacob Skaria]

Dear Elton

Select the range of dates which needs to be corrected. From menu Data>Text
to Columns will populate the 'Convert Text to Columns Wizard' Hit Next>Next
will take you to Step 3 of 3 of the Wizard. From Column Data format select
Date and select the date format in which your data is (DMY).Hit Finish.

MSExcel will now convert the dates to the default date format of your
computer. Now you can custom format to required date format..

If this post helps click Yes

 

[Jacob Skaria]

Dear Elton

Select the range of dates which needs to be corrected. From menu Data>Text
to Columns will populate the 'Convert Text to Columns Wizard' Hit Next>Next
will take you to Step 3 of 3 of the Wizard. From Column Data format select
Date and select the date format in which your data is (DMY).Hit Finish.

MSExcel will now convert the dates to the default date format of your
computer. Now you can custom format to required date format..

If this post helps click Yes

 

[Gary''s Student]

IF your data is in column A as text, then in B1:

=datevalue(A1) and copy down

Then format column B as Data in any format.

 

[Gary''s Student]

IF your data is in column A as text, then in B1:

=datevalue(A1) and copy down

Then format column B as Data in any format.

 

[Elton Law]

That's great !!!!
Thanks indeed

Dear Elton

Select the range of dates which needs to be corrected. From menu Data>Text
to Columns will populate the 'Convert Text to Columns Wizard' Hit Next>Next
will take you to Step 3 of 3 of the Wizard. From Column Data format select
Date and select the date format in which your data is (DMY).Hit Finish.

MSExcel will now convert the dates to the default date format of your
computer. Now you can custom format to required date format..

If this post helps click Yes

 

[Elton Law]

That's great !!!!
Thanks indeed

Dear Elton

Select the range of dates which needs to be corrected. From menu Data>Text
to Columns will populate the 'Convert Text to Columns Wizard' Hit Next>Next
will take you to Step 3 of 3 of the Wizard. From Column Data format select
Date and select the date format in which your data is (DMY).Hit Finish.

MSExcel will now convert the dates to the default date format of your
computer. Now you can custom format to required date format..

If this post helps click Yes

 

[Jacob Skaria]

Cheers..

 

[Jacob Skaria]

Cheers..