How Excel splits similar terms

Maybe you know how to merge similar terms in Excel, so does splitting similar terms know? There may be a lot of small partners who don't know how to operate. So let's take a look at this tutorial together.

How Excel splits the similar terms Excel split similar terms tutorial

1 can be referenced by a formula, but not by using a function.

The 2 method applies to bulk operations of data.

Action method as shown:

1, the PivotTable method: The combination of multiple areas of the PivotTable report, merging the view details of the merged rows. You can get a schedule that is similar to the result. A little processing is the answer to the question.

2, find the replacement method: the use of the cut version and the formula bar, replace, replaced with line breaks, and then the processing of the breakdown.

3, the use of circular reference method. The advantage of this method is that it is easy to operate and suitable for large amount of data.