Correct data imported into Excel from a database

Posted on:  08/09/2017
Correct data imported into Excel from a database

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.

Video of correcting Excel file

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 15 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories