Shulou(Shulou.com)11/24 Report--

The title of the original text: "many columns are merged into one column, this Excel trick is wonderful!" "

As soon as I was about to get off work last night, the boss sent me a "task"-to convert the names on this list into a list of forms!

╭ (╯ ^ ╰) ╮, don't make me work overtime!

Procedure:

❶ selects the data and copies it into the Word document.

❷ in the document, click anywhere on the list, click "layout tab" and select "convert to text".

❸ in the "text separator", click "paragraph mark"; finally paste the data into the Excel table, done! Multi-row and multi-column data is listed into one column!

Have you learned this little trick?

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.