Convert text to date.
-
I hope you can assist me with my formula to convert text to date. This is the text: Sunday, February 28, 2010 convert this text to Sun 28-Feb I was hoping with a formula I could change its format to date. I tried using =DATEVALUE(A1) it comes up with an error. I appreciate your assistance.
-
Answer:
There are so, so many ways to answer this question, and variables depending on how much text you have in what cells, how are they formatted, etc. etc. Can't you just reformat the source cell as Date? Otherwise, I coiuld consider some steps like this: in a new column, format it all as Date, nothing but DDD then formula in that column to get left(cellwithtext,3) this should return SUN and also be formatted as date. use that same type of method for the other parts of it. if you want, email me sheet to [email protected], maybe I can help do a one time clean up.
Miningco.com Visit the source
Related Q & A:
- How to Convert Json date string to more readable date format?Best solution by SharePoint
- How to store global date time and convert it to local date time?Best solution by Stack Overflow
- How to read text off an embedded text resource?Best solution by Stack Overflow
- How to convert full date/time to timestamp?Best solution by Stack Overflow
- How to convert a GMT timestamp to proper Date in PHP?Best solution by stackoverflow.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.