|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 17th, 2010, 09:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract dd and mm from text and put that plus current yy in another
I've got a workbook which comes from someone else and it's got a cell
in it from which I want to get the above. The format of the cell varies. It could be texttexttext 17Feb09, texttexttext 17th Feb, texttexttext 17 February 09, texttexttext 17th February 2009, etc (but never Feb 17 - I'm in UK not US!) 
|
|
#2
February 17th, 2010, 10:14 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract dd and mm from text and put that plus current yy in another
Try Text to Columns (in the Data menu). It should convert most every date
for you. Regards, Fred "robzrob" wrote in message ... I've got a workbook which comes from someone else and it's got a cell in it from which I want to get the above. The format of the cell varies. It could be texttexttext 17Feb09, texttexttext 17th Feb, texttexttext 17 February 09, texttexttext 17th February 2009, etc (but never Feb 17 - I'm in UK not US!)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
