TXT to Excel form, you need 1 hour, I will finish it in 5 seconds.

Hello, everyone! I'm Chang Xiao an.

My boss called me before I got off work today:

"Xiao an, I have a notepad file here that contains the company's personnel information. Enter them into the Excel form and send them to me before you get off work. "

Me: "OK, I'll do it right away." "

I opened my notepad and saw that all the data were huddled together in a column of ↓↓↓

If you use the copy-paste method, it will take a lot of time.

But if we take a closer look, it is not difficult to find that in this data, all the information is separated by a comma.

With a fixed delimiter, it takes only 5 seconds to make a table quickly using the [separate] function.

Let's see how to do it.

👉 procedure:

❶ copies and pastes data into Excel

❷ select data, [data]-[separate]-"next"-"Separator" Select a comma, and click next

❸ select the [ID number] column, "column data format" select the text, complete.

❹ adjusts the column width to beautify the table.

All right, the task is done easily. I'm off duty.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Chang Xiaoan Editor: Tian Guoguo