The Issue at Hand: Excel data mixes text and numbers. Excel columns are defined as “Text”. How can one work around the data in Excel in a way that allows to create a numeric expression?
Below is an example of “text” Excel data (data into the cells).
There may ways to solve this. Below are two approaches:
,PurgeChar( [Annual Salary],’$,’) AS Salary1
,Mid([Annual Salary],2) AS Salary2
FROM …my Excel;