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