I have a spreadsheet where dates are true text strings such as February 25 2015 (no punctuation) and I want to reformat them to actual date formats so I can sort accordingly.
I have a spreadsheet where dates are true text strings such as February 25 2015 (no punctuation) and I want to reformat them to actual date formats so I can sort accordingly.
Hi, welcome to the forum
If you want to do this to the column that the dates are in...
Highlight the range
click Text2Columns on the Data tab
select delimited/Next/Next
select Date and change format if needed
click Finished
If you want to do this in a helper column, assuming your date is in A1...
=DATEVALUE(LEFT(A1,SEARCH(" ",A1,SEARCH(" ",A1,1)+1)-1))
copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Or this
=SUBSTITUTE(TRIM(MONTH(1&LEFT(A1,3))&" "&RIGHT(A1,7))," ","/")+0
format cell as Date
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)
Bookmarks