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
Correct Excel file with T function, value, text to columns by Chris Menard - YouTube
