text to columns shifts data to other rows

  • Thread starter Thread starter ceexcel
  • Start date Start date
C

ceexcel

When I use text to columns specifying a fixed width, after the split is done
some of the information in the cell(s) that was split has been shifted to
rows above the row where the data was originally.
Has anyone else encountered this and what is the resolution.
 
When I use text to columns specifying a fixed width, after the split is done
some of the information in the cell(s) that was split has been shifted to
rows above the row where the data was originally.
Has anyone else encountered this and what is the resolution.
Click to expand...

No, that doesn't seem to compute....
 
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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Text to columns 2
Excel Move or Copy Stopped Working? 0
Split column contents (de-concantenate) 7
Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1
I can only delete an entire row not a cell in excel 2013? 1
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2

Back
Top