Excel learning to quickly split keywords in cells

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.

Step 1

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:

Step 2:

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!