Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing text from a date
Hi
I have a date field in a spreadsheet that is coming from another system as a text fled and contains charatcetrs I wish to remove. And I want the output to just be dd/mm/yy. Problem is I can't just count overall characters and remove left and righ becuase sometimes there is an asterisk and sometimes the date has 2 characters for the number ie 10 Jun as opposed to 5 Jun. Example below.... Thu, 5 Jul 07* Anyone got any cunning plans around a formulae to clean this up and output just a date? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing text | Excel Discussion (Misc queries) | |||
Removing Text | Excel Worksheet Functions | |||
removing date data from a cell | Excel Discussion (Misc queries) | |||
removing year from date | Excel Worksheet Functions | |||
Removing text characters | Excel Worksheet Functions |