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 08: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
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks