Shulou(Shulou.com)06/01 Report--

This article mainly shows you "Excel how to use Ctrl + e to complete data split operation", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "Excel how to use Ctrl + e to complete data split operation" this article.

Ctrl + e completes data splitting operation

Sometimes some data is mixed into a cell and we need to separate it. You may think of using the excel function at this time, but there is also a good way to read on.

Note: only for the first row of data processing. The first step: copy the name to the last name column and the score to the score column; the second step: place the cursor on the second row of each column and use the key combination ctrl+e to complete the fast filling operation

The above is all the contents of the article "how Excel uses Ctrl + e to complete data splitting operations". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.