Excel 2016 from Scratch

Import Text

An Excel tutorial by Peter Kalmstrom

Excel 2016 iconIn this demo in the Excel 2016 from Scratch series, Peter Kalmstrom shows two different ways of reaching the Text Import Wizard to add data from a text file into an Excel sheet.

One way is to select all text by using the,Select All? option or using keyboard Ctrl A and then copy it and use a paste option in Excel that gives you the wizard.

The other way is to reach the wizard by using the,From Text??? button under the Data tab in the Excel ribbon.

This is what Peter showns in the demo below:
  • How to choose the file type to describe data in the best way.

  • How to see text delimitors in Word.

  • How to keep the headers data as headers when importing.

  • How to change the format of the data in a column.

Peter uses Excel 2016 for his demo, but the Excel basics are the same for earlier versions of Excel.

Learn more

Office 365 from Scratch cover SharePoint Online from Scratch cover SharePoint Online Exercises cover
SharePoint Workflows from Scratch cover Excel 2016 from Scratch cover SharePoint Flows from Scratch cover

Always the latest news in the kalmstrom.com blog

Follow kalmstrom.com on LinkedIn Facebook, Google+  or Twitter!

back icon next icon

Products Buy FAQ Services Tips Services Books Contact About Us Blog

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved