Hello All. I have text which contains general text reflecting date & time. The general text would look as follows: "Saturday 10 June 2011 Time 22H00". I need to extract first the date only from each cell and copying it to the next column, and the same with the time. How would I do that? Sheet sample attached. Thank you very much
Last edited by speedbird168; 02-09-2012 at 07:39 AM.
The date is a tricky since you have lots of variants
For the time use this
=TIMEVALUE(SUBSTITUTE(UPPER(RIGHT(A2,5)),"H",":"))
and set the format to time to display a time rather than a decimal number
Regards
Special-K
I rarely return to a problem once I've answered it so make sure you clearly define what the trouble is.
Superb solution. Many thanks Special-K.
If I were to try the DATEVALUE formula on "Saturday 10 June 2011 Time 22H00", what would be the 'old text' and 'new text'?
Still battling to extract date only from the data. Anybody have any suggestions on how to configure the DATEVALUE in this case? Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks