LinkBack URL
About LinkBacks
Assuming date is in A1
Formula in B1, Format as Date
Formula:
=--REPLACE(A1,FIND(" ",A1),LEN(A1),"")
Or
Formula:=--REPLACE(A1,11,LEN(A1),"")
Assuming date is in A1
Formula in B1, Format as Date
Formula:=--REPLACE(A1,FIND(" ",A1),LEN(A1),"")
Or
Formula:=--REPLACE(A1,11,LEN(A1),"")
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks