Text to Columns Function Problem

  • Thread starter Thread starter whoray
  • Start date Start date
W

whoray

When I use the text to columns function in Excel the column that the split
data is dripped into shits up one row. Is ther a way to avoid this?
 
I bet you misspelled "dropped" and "shifts". <vbg>.

And I bet you select the whole column and the column has empty cells at the top.

You can either be more specific with your selection (A3:a9999 instead of all of
column A) or maybe just put some temporary values in those blank cells at the
top.

Actually, the only way I could reproduce this is when the usedrange of the sheet
didn't include the top row(s).

If I put anything in row 1, hit enter, and then cleared its contents, data|text
to columns worked ok (and didn't _shift_ the data up).
 
Back
Top