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:
- T function
- Text to columns
- CTRL + H for replace
- Trim function
- Convert text to numbers
- Convert text to dates
- 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 Teachable.com
Through August 2017, the $199 course is only $29. There are over 7 hours of material and you follow along with me.
YouTube Video of correcting Excel file