How would I turn a "sentence" like "Monday March 18, 2013" into a proper date like 03/18/2013?
How would I turn a "sentence" like "Monday March 18, 2013" into a proper date like 03/18/2013?
Try this
=REPLACE(A1,1,FIND(" ",A1),"")+0
Format the cell with the formula in the date format of your choice.
Thanks for the response.
I did find a very long about way of doing it but thought I would share.
I used the "Text to Columns" feature to separate each part of the "sentence" and was then able to reformat the data as needed and then concatenate the data simply using = A1 & "/" & A2 etc.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks