How to Import a Text file into Excel - Office 365

preview_player
Показать описание
How to Import a Text file into Excel - Office 365. This video explains how to import data from a text file in to excel.
Рекомендации по теме
Комментарии
Автор

Thank you. Perfect. Everything I needed to know.

houstonewton
Автор

Thanks...but my problem is changing the data type when you're loading. For example, your first field 001 shows up as 1 after you load because it made it numeric. With Excel 2010, I could change it to a text field so I could have it shows as 001 on the spreadsheet. Can't get this to work in Excel O365.

mrscnln
Автор

office 365 is the bane of my fucking existence man.

TruVibezz
Автор

Ohh, did not work for me as I have multiple columns

gracea
Автор

What if the delimiter does not show up?

tamchau