Home |
Search |
Today's Posts |
#1
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
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!) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to extract text from number/text cell | Excel Worksheet Functions | |||
Need to extract certain text from text string | Excel Worksheet Functions | |||
EXTRACT TEXT FROM TEXT STRING | Excel Worksheet Functions | |||
extract date from the most current date | Excel Discussion (Misc queries) | |||
how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) |