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

Original title: "batch extraction of file names, you are still using copy and paste?" "

It's time to get off work, cousin: boss, I'll get off work first.

Boss: huh, dare to provoke me! Look, I won't stop you.

In order to prevent him from leaving work on time, the boss, together with sister Word, assigned him a task-extracting file names.

Doesn't that sound simple? But the goose. There are 3000 of these documents.

[Ctrl+C], [Ctrl+V] are obviously not good, tired and time-consuming.

At this time, my cousin demonstrated his powerful Excel skills!

Extract 3000 file names in batches every minute, and get off work on time successfully!

Want to know how cousin did it? Just look down and you'll see!

First of all, make sure that all files are in the same folder.

Then, you can start to extract the file name ~

❶ [Ctrl+A] Select all files and click the copy path button above. This is it.

Paste the copied path into Excel:

❷ copies the extra parts (except for the file name), and [Ctrl+H] calls up the replacement dialog box:

Paste ❸ into the search content, replace it with blank, and click "replace all":

All the file names will be extracted and done in 10 seconds!

Next, let's look at how to create a worksheet with a specified name.

Create a worksheet by the specified name here, using the PivotTable function, you can create it in batches.

❶ select the table, and click "insert"-"PivotTable"-"OK"

❷ drag the name to the filter area, click [PivotTable]-[options]-[Show report filter Page], and click "OK".

The worksheet has been created, and my cousin has finished work successfully.

Summarize two tips shared with you today:

Batch extract file name

Creates a worksheet by the specified name.

Follow Qiu Xiao E and learn skills every day. Getting off work on time is not a dream!

Did you expect that?

To extract the file name, there is such an efficient method!

If you want to improve your work efficiency and get off work early every day, you might as well learn Excel skills.

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

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.