• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to remove the ' from date field when downloading to Excel from a DB

red_leader

red_leader

New Member
Hi Ninjas! I hope this is easy for you, but it has bedeviled me for months. When I download Excel extract reports from our databases, the dates are always in a general format and preceded by a ' (i.e., 'MM/DD/YYYY"). I want to be able to easily convert these to true dates by changing the cells to a date number format (MM/DD/YY), but the presence of the ' means that the dates won't convert over. How do I remove the ' so that the dates will convert?
 
Hi,

In my opinion, the simplest way is to use the Text to Columns tool.
Simply select the range of dates where you have the ' and click the Text To Columns and then just hit finish (you shouldn't need to select any options).

And you should be good to go :)
 
OMG!! My jaw has completely dropped! This is awesome! Worked like a charm... I feel so powerful now! Thanks a bunch for this tip - live long and prosper, my friend!
 
You must log in or register to reply here.
Back
Top