Share via

Excel Text Import Wizard - Fixed width data - shifting column breaks

Anonymous
2018-09-20T07:10:51+00:00

When using the Text Import Wizard the column breaks shift when scrolling right from first column in steps 2 and 3.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2018-09-20T07:23:34+00:00

    As per your picture. yes shifting is happening. It is a never encountered problem (for me).

    I need to experiment. Can you share few lines of your csv files throgh Onedrive without any confidential / sensitive data?

    0 comments
  2. Anonymous
    2018-09-27T06:38:44+00:00

    Since your reply I was trying to repeat the shifting, with no success.

    Maybe it was a particular sequence of actions (removing/adding/moving column breaks, moving to the next step and back again,...). :S

    Luckily I documented this the one time it happened or none would believe me. ;)

    As there is no confidential data, I'm pasting a few lines here:

    Napaka na dokumentu 'ERP2C4138310E481EE8AEE197B72C718E18I001': Dokument z oznako 'ERP2C4138310E481EE8AEE197B72C718E18I001' ni bil najden v tabeli izmenjav.

    Napaka na dokumentu 'ERP2C4138310E481EE8AEE197B7F2B34E18I001': Dokument z oznako 'ERP2C4138310E481EE8AEE197B7F2B34E18I001' ni bil najden v tabeli izmenjav.

    Napaka na dokumentu 'ERP2C4138310E481EE8AEE197B8CB204E18I001': Dokument z oznako 'ERP2C4138310E481EE8AEE197B8CB204E18I001' ni bil najden v tabeli izmenjav.

    Napaka na dokumentu 'ERP2C4138310E481EE8AEE197BA1D79CE18I001': Dokument z oznako 'ERP2C4138310E481EE8AEE197BA1D79CE18I001' ni bil najden v tabeli izmenjav.

    0 comments