Query returns blank cells where there should be data

W

WillrSF

I've create a query to pull a table of account codes from another Excel
worksheet. The table includes numbers enter as text (e.g., 03, 2993LB) and
columns with text only. The query returns all the entries in the text only
column, but returns blanks for entries like "2993LB" and for other cells in
columns with numbers are formatted as text--it returns most of the cells in
the column but not others. Any clues on this issue?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP returns 0 (zero) when lookup cell is blank 5
Two columns followed by single page-width column on same page 0
Matching data in columns 1
Macro that sorts data with blanks at the bottom 1
Having Blank Cells, etc. ? 1
Extracting data from range and placing in one cell with comma'sbetween while ignoring blanks 5
identical formula returns #VALUE! error 3
Excel 2003 - Importing External Data - formatting problem? 2

Top