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).
 
You must log in or register to reply here.

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

Text to columns 2
Getting Text data using the Data - Subtotal feature 1
Split column contents (de-concantenate) 7
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Text to Columns Problem 4
Conditional SUBTOTAL in XL210 Table 7
Splitting text 11
Split cells across multiple columns 1

Back
Top