I have a column that with date and time that was automatically entered with no space in between the date and time (2018-08-0812:15:38.156). This seems to make it impossible to format the date using format cells. Just wanted to see if any of you know how I can change this column to have a space in between the date and time without going through every cell, thanks.
In B2 copied down:
=DATEVALUE(LEFT(A2,10))+TIMEVALUE(MID(A2,11,99))
Format column B as date and time to your liking.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try this
Format Custom, "m/d/yyyy h:mm"
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Doh! Overthinking things again ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks