I have an Excel spreadsheet that has a column with both numbers, such as 68, and a combination of numbers and letters, such as 1D. When querying this via Microsoft query, the records with the letters show up blank. It only pulls in the records with the numbers. The column in my original spreadsheet is formatted as "General". I've even tried changing to "text" and that didn't work. Any suggestions?
Cheryl
Cheryl