This article brings you relevant knowledge about excel, which mainly introduces how to quickly split keywords in cells. Let’s take a look at simple and efficient data cleaning techniques. ,I hope everyone has to help.
Related learning recommendations: excel tutorial
Share a simple and efficient data cleaning technique.
Let’s look at the data source first. It is a list of keywords for e-commerce searches. All content is squeezed into one cell, and each keyword is separated by commas:
Now, we need to split these keywords into a column, with each keyword in a separate cell.
Friends who use version 2016 and above can load it into the Power Query editor and select Split Column → By Separator → Split to Rows.
We have shared this method before, and today we share a method that can be implemented in any version of Excel.
Press the Ctrl H key to bring up the [Find and Replace] dialog box, enter a comma in the [Find content] text box, and click in the [Replace with] text box Click once and press Ctrl J (note that there is only a flashing black dot in the text box at this time. This is the line break to be replaced. Do not press the key combination again).
Finally press the [Replace All] button to replace all commas with newline characters.
The effect after replacement is like this:
in the editing bar Click once, press Ctrl A to select all, then right-click (or press Ctrl C) to copy.
Click any blank cell, press Ctrl V to paste, OK.
Just talk and don’t practice fake moves. Today’s practice file is here. You can try it too.
Related learning recommendations: excel tutorial
The above is the detailed content of Excel learning to quickly split keywords in cells. For more information, please follow other related articles on the PHP Chinese website!
