Share via

Excel: Import text file with fixed width data

Anonymous
2018-05-04T12:20:54+00:00

Hi

I can't find a way to import a text file in Excel which contains fixed width data.

It worked earlier but since the new importer (with Power Query Editor) it doesn't work anymore.

I tried this steps: https://support.office.com/en-us/article/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857 (Step 2 of 3 (Fixed width data))

Any hints?

Thank you

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

Answer accepted by question author

Anonymous
2018-05-04T12:48:21+00:00

Pls refer the link below for the steps to activate the legacy option..

http://professor-excel.com/import-csv-text-files-excel/

or u can copy paste the data in excel and use Data>Text to columns

Was this answer helpful?

10+ people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-05-15T22:17:39+00:00

    Hi Philippe,

    Does the link above work for you?

    Regards,

    Tisky

    Yes, thank you for asking, and thank you for the help xl_geek

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-05-08T07:47:45+00:00

    Hi Philippe,

    Does the link above work for you?

    Regards,

    Tisky

    Was this answer helpful?

    0 comments