Ever been stuck with a list in "comma delimited" format? Working with one GIANT block of text in a txt file is pretty much impossible, but luckily, it's not difficult to transfer it to a properly organized excel file by following these simple steps:
0:00 - Intro
1:11 - How to copy all the text
1:32 - What do to in Microsoft Excel
2:04 - Data, Text to Columns, Delimited, Check "Comma", General, Finish
Copy and paste all of the text into a new excel file
Highlight the column that contains your list.
Go to Data (in the toolbar), then click on "Text to Columns"
Choose Delimited. Click Next.
Choose Comma. Click Next.
Choose General or Text, whichever you prefer.
Leave Destination as is, or choose another column. Click Finish.
Give it a try and you'll see what I mean - it's pretty easy!
Смотрите видео How to Convert a Comma Delimited txt File to a Microsoft Excel xls File онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал REtipster 10 Октябрь 2015. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 75,098 раз и оно понравилось 441 посетителям.