Thread: Split Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Elton Law[_2_] Elton Law[_2_] is offline
external usenet poster
 
Posts: 173
Default Split Date

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,