Denver DataMan Blog

Riding the Waves of the Everchanging Web

Using Text to Columns to Separate Text in Excel

I found myself with a conundrum when trying to fix dates so they could be imported correctly into a database.  The existing database was exporting dates like this “1943-08-24T00:00:00Z” I need the dates in DD/MM/YYYY format.

The first thing I tried was to use the left function to extract the first 10 characters which gets me the date.  However for some reason the left function would not let me change the output to the right date formula. 

Follow-up from Steamboat Springs Office Session

thank you to everyone who came out for the session.  I am  still researching a way to select a specific cell across multiple sheets with a fornula in Excel.   Please email me if you want me to email you when this post is updated with a solution.  -Steve 

Mobile Friendly Moves SEO on Google

According to Google they will now be looking to how “mobile friendly” your site is to determine your ranking in search. This is a very big departure from other search ranking changes. Denver DataMan will post more information on this topic as it comes available.