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

Original title: "how smart is the King of filling [Ctrl+E]?" After reading this article, you will understand! "

In our work, we often have to process data in batches, such as:

❶ batch extracts the date of birth from the ID card

❷ codes the mobile phone number in batch.

❸ adds book titles to the data in batches.

It all looks complicated and seems to need to use all kinds of functions.

In fact, as long as [Ctrl+E] quickly populate, you can easily solve these problems.

ID card number extraction date of birth in the following data, there are more than 1000 employee information, now according to the ID number, the date of birth will be extracted and put in column D.

The 7th and 14th digits of the ID card number represent the date of birth, and you just need to extract them.

The traditional way is to copy and paste, or to extract by function formula.

But in front of [Ctrl+E], it only takes two steps to get it done!

👉 procedure:

❶ enters the boss's date of birth in cell D2.

Click [Ctrl+E] on ❷, and all the birth dates are filled in!

Isn't it so simple?!

Batch coding of mobile phone numbers in order to protect employee information, companies often code employees'ID numbers, mobile phone numbers, and so on.

For example, the following mobile phone number information needs to code bit 4-7 and change it to four asterisks (*).

With [Ctrl+E], it can also be easily done in batches!

👉 procedure:

❶ enters the mobile phone number coded on the left in the D2 cell.

Click [Ctrl+E] on ❷, and all the phone numbers are filled in!

Compared to the function, this is not much simpler!

Batch adding title number also has such a data: contains more than a thousand titles, now need to add a batch of title number "".

Similarly, it can be solved with [Ctrl+E]!

👉 procedure:

❶ enter the name of the book with the title number "" in the C2 cell

Click [Ctrl+E] on ❷ and add it in batches!

To sum up, this article mainly introduces three usage scenarios of [Ctrl+E].

❶ extraction data: use [Ctrl+E] to extract specific digits of ID card number in batches

❷ modify data: use [Ctrl+E] to replace specific locations of mobile phone numbers with asterisks in batches

❸ add data: use [Ctrl+E] to add title numbers for book titles in batches.

Rational use of [Ctrl+E] can greatly improve work efficiency! Do you agree?

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Chang Xiaoan, 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.