ctrl e is an important shortcut key in Excel. Text splitting, information extraction, information merging, formatting adjustment and number extraction from text can all be achieved through this shortcut key.
The most magical shortcut key in Excel2013 and Excel2016 is Ctrl E. With this shortcut key, text splitting, information extraction, and data merging are all a breeze, and you no longer need to write anything annoying and complicated. It’s a formula, you only need one click to do it, and your work efficiency will be doubled. It’s really a magical shortcut key that makes people applaud!
【Recommended course: javascript tutorial】
(1) Extraction of information
Extract name, phone number, city, and age information from the combined information
Operation points: Enter the first name first, Select it and the blank line below, press ctrl E, the name will be filled in 1 second, the same operation is done for the phone number, city and age
( 2) Information merging
Combining names and phone numbers
Operation points: Enter the first combined information first, tell Excel how to combine it, and then select the first information and the remaining information. In the cell range below, press the ctrl E shortcut key
(3) Adjust the format
Display the phone format in segments
Operation points: First enter the first segmented number, then select this number and the area below, press Ctrl E
(4 ) Extract numbers from text
Operation points: Enter the first number first, then select this number and the area below, press Ctrl E
Of course, Ctrl E cannot handle all needs 100% perfectly. After all, with more complex data processing, the software may also have deviations when judging our real needs. Therefore, for more complex data, sometimes you may need to fill in 2 or The values of more than 2 cells are provided to CtrL E for judgment. The results should be checked after the data processing.
Summary: The above is the entire content of this article, I hope it will be helpful to everyone.
The above is the detailed content of What is the shortcut key for ctrl+e?. For more information, please follow other related articles on the PHP Chinese website!