Forum Discussion
Import text file
Hi all, My Office 365 has recently updated with the new wizard for importing data. I work with a number of text files which I import into excel using the Text Import Wizard. I would insert Fixed wid...
A way to replicate the legacy wizard is to import the text file using the new wizard and formatting it to just one column, then use the Text to Columns feature to insert column breaks using mouse clicks.
Hi Ross,
Yes, Text to Column actually uses the same engine as legacy wizard, just another entry into the it.