| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y | Excel Discussion (Misc queries) | |||
| Split DATE cell into three new cells? | Excel Worksheet Functions | |||
| Split Date and Time Cell | Excel Discussion (Misc queries) | |||
| how to split the cell which has the date formula (with day) | Excel Discussion (Misc queries) | |||
| Split date and time | Excel Discussion (Misc queries) | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
