Correct data imported into Excel from a database

by | Aug 9, 2017

A client sent me an Excel file they pulled from a database. I had to correct the dates, numbers, and text so I could do calculations.

In this blog post, I cover:

  1. T function
  2. Text to columns
  3. CTRL + H for replace
  4. Trim function
  5. Convert text to numbers
  6. Convert text to dates
  7. Value Function

T Function in Excel

If the value is or refers to text, T function returns the value. If the value does not refer to text, T returns “” (empty text).

You do not generally need to use the T function in a formula because Microsoft Excel automatically converts values as necessary. This function is provided for compatibility with other spreadsheet programs.

Value Function in Excel

I use the Value function to change what appears as a date but is actually text to a true date.

Excel Training Online Course

My Excel Intermediate Training course is now online with the LMS company

Through August 2017, the $199 course is only $29. There are over 7 hours of material and you follow along with me.

Online Excel Training with Chris Menard

YouTube Video of correcting Excel file


chris menard on Linkedinchris menard on Youtube
chris menard
Microsoft Office Master Instructor
I train corporate clients in Microsoft Office Excel, PowerPoint, Word, and Outlook. When I'm not training, I blog about technology and create training videos on YouTube. I currently have over 240 technology videos available. Most of the videos I've created come from questions asked during MS Office training.

Pin It on Pinterest