text to columns shifts data to other rows

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.
 
C

CurlyDave

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....
 

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

Cell data entering slow! 0
Text in note pane of "normal" display suddenly much larger 1
Text to columns 2
Unable to set the desired column width for a table with merged cells 0
Unable to set the desired column width for a table with merged cells 0
"cannot shift objects off sheet" error 8
+/- Character String Ommitted in Excel 2003 Text Import 0
Text To Column max 26 characters 7

Top