Excel Tips [Extract all file names in a folder]

In this series of articles on Excel techniques carefully compiled by php editor Youzi, today we will share how to extract all file names in a folder in Excel. This tip will help you organize your files quickly and be more productive. Let’s learn together!

Do you still know how to copy and paste one by one? nonono!

Do this and it will be done in 3 seconds!

1. Select all files (Ctrl A), right-click and select [Copy File Address], whether it is a folder or a document in other formats;

2. Open the excel table and paste the file address you just copied into the table (Ctrl V);

3. Press Ctrl H to open the find and replace box, enter [*] in the search content, and select [Replace All]

4. You can get the file names of all files.

If you need an Excel password tool, click here to get it: Pepsi Niu Excel Password Recovery Tool

For more office tips, welcome to the homepage of Pepsi Niu Technology~

Many office gadgets are available on www.passneo.cn official website~

The above is the detailed content of Excel Tips [Extract all file names in a folder]. For more information, please follow other related articles on the PHP Chinese website!