picturepicturepicture

Tanabata romantic date "Hui"

Super Member Lifetime Card 23% off for a limited time

The original price is 168. Sign up today for only 129!

Don't miss it. ヾ(◍°∇°◍)ﾉﾞ

‍picture

1. Quickly add prefixes

Add the prefix "Aichiqu-" in front of the name in batches:
picture

Enter in cell B2: Aichiqu-Look, press Enter, and press <Ctrl+E>.

picture

2. Capitalize the first letter of a quick English sentence

Capitalize the first letter of English sentences in column A to display:
picture
Enter in cell B2: Good morning., press Enter, and press <Ctrl+E>.
picture
3. Quickly extract the date of birth from the ID number
The 7th to 14th digits of the ID number are the date of birth. How can I quickly extract it?
picture
Enter: 19840904 in cell B2, press Enter, and press <Ctrl+E>.
picture
4. Quickly merge cell contents
Merge names in column A with mobile numbers in column B:
picture
Enter in cell C2: look up 13509621566, press Enter, and press <Ctrl+E>.
picture
5. Quickly split content
How to split the name and mobile number in column A?
picture
Enter in cell B2: look up, press Enter, press <Ctrl+E>;
Enter: 13509621566 in cell C2, press Enter, and press <Ctrl+E>.
picture
6. Quickly display mobile phone numbers in segments
For the convenience of viewing, the mobile phone number needs to be displayed in segments. What should I do?
picture
Enter in cell B2: 135 0962 1566, press Enter, and press <Ctrl+E>.
picture
7. Quickly swap positions
Swap names in column A with mobile phone numbers:
picture
Enter in cell B2: 13509621566 look up, press Enter, and press <Ctrl+E>.
picture
8. Quickly remove spaces
There are spaces in the ID number in column A, how to effectively remove the spaces?
picture
Enter the ID number in cell B2: 12010519840904781X, press Enter, and press <Ctrl+E>.
picture
9. Quick line feed display
Quickly wrap the departments and names in column A to display:
picture
Enter in cell B2: Administration Department, press <Alt+Enter> to wrap the line, then enter look up, press Enter, and press <Ctrl+E>.
picture
10. Quickly replace characters
In order to protect personal privacy and prevent the leakage of the mobile phone number, it is necessary to replace the 4th to 7th digits of the mobile phone number with asterisks (*). What should I do?
picture
Enter: 135****1566 in cell B2, press Enter, and press <Ctrl+E>.
picture
That's all for today's sharing. If the tutorial is useful to you, I hope you will share and support the editor! Every like and repost of yours is the motivation to support the editor to insist on originality.
      
     
            
     
   
          
picture
Why choose us, the platform advantage is there
Advantage ①: VIP can learn all tutorials, unlimited learning + supporting material source files + unlimited downloads
Advantage 2: Support WeChat public account + applet + APP + PC website for multi-platform learning
Advantage ③: Support offline viewing, double-speed viewing, allowing you to learn anytime, anywhere
Advantage ④: VIP logo, distinguished status + independent after-sales group answers
picture
picture
★ FAQ ★ 
①Xiao Ai: Can you watch all the courses after buying VIP ?
Well, yes, including future updates (thanks for your support, we will insist on high-quality teaching updates)

②Xiao Ai: Hello, how do you study ?
Pay attention to the Aizhiqu Education service account, you can directly enter the official website to learn from the menu navigation, or you can enter the applet and download the APP!
Computer login to https://www.92zhiqu.com
(Mobile phone, computer learning is essential)

③Xiao Ai: what to do if you do n’t understand
Provide after-sales answers, pay to contact customer service and join the group (pay to contact WeChat customer service, just take a screenshot)

④Xiao Ai: Provide video courseware materials ?
Well, original high-definition video, these are provided (original tutorial, these are the most basic requirements)

⑤Classmate Xiao Ai: Validity period of study ?
Annual membership and lifetime membership, unlimited lifetime membership (self-built website + original tutorial + Aichiqu brand guarantee)

⑥ Primary school students: Does the website support accelerated viewing ?
kindness. At present, mobile phone applet + APP + computer PC all support 1.5 times accelerated viewing or slow playback

⑦ Does the course support offline download ?
kindness. Both Android and Apple IOS APP support mobile phone offline download
Computer downloads are provided by contacting WeChat customer service 18074746783.

⑧ How about the quality of the course ?
Aizhiqu Education high-quality video as the starting point, high-definition subtitles, support for audition

pictureIf there is anything else you need to consult, please contact WeChat customer service 18074746783
Long press to identify the QR code "Add Customer Service"
picture
pictureClick to read the original text , log in to the official website with one click, and learn from a large number of video VIPs! (you can try it out)