Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to quickly create 200 folders in batches with the help of Excel

2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > IT Information >

Share

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

Hello, everyone! I am a classmate of Chang Xiaoan.

I was leaving work in five minutes. I was thinking about what to eat when suddenly my boss called me:

Xiao an, I have a list of all the people in the company. Please make these names into separate folders for me before you get off work.

Me: OK, leave it to me!

It's clear that I have to work overtime!

I looked at the file and found the names of more than two hundred people.

Seeing here, do you think I'm going to create a new folder and use the copy-and-paste method to change the folder name one by one?

No, no, quickly create a new folder by name. I have a faster way.

Using notepad, you can easily do it in three steps!

Next, let's take a look at the steps:

❶ [Ctrl+A] Select all data, right-click-"paste selectively"-"transpose", and change the data to landscape orientation.

❷ copies the transposed data, creates a new notepad, enters "md" and a space in it, and then pastes the copied data into it.

❸ click [File]-[Save as], the suffix of the file name is changed to bat, and the encoding is changed to "ANSI". Double-click the bat file after saving, and you can generate folders in batches by name.

Unexpectedly, notepad can still be used in this way.

More than 200 folders were taken care of in less than a minute.

Pack my bag and get ready to get off work! (go to eat hot pot in the evening, hey ~)

PS: if the suffix .txt is not displayed after creating notepad on your computer, you can open any folder, click [View]-- check [File extension], and it will be displayed!

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: witty Qiu Xiao E

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

IT Information

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report