Split columns by digit to non-digit

In Power Query, you can split a column through different methods. Among the available split options in Power Query, this article examines how to split the selected column or columns wherever a digit comes before a non-digit.

Where to find Split columns > By Digit to Non-Digit

You can find the Split Columns: By Digit to Non-Digit option in three places:

• Home tab—under the Split Column dropdown menu inside the Transform group.

  

• Transform tab—under the Split Column dropdown menu inside the Text Column group.

  

• Right-click a column—inside the Split Column option.

  

Split columns by digit to non-digit into columns

The initial table in this example is the one shown in the following image, with a column for Pets and other extra columns. This example only focuses on the Pets column.

This column holds two values in each row:

• Rank—The rank of the animal.
• AnimalType—The second part of the word is the type of animal.

In this example, you want to split this column into the two columns described in the previous list. Select the column and then select the split column by digit to non-digit option.

This single column splits into multiple columns, given every instance of a digit followed with a non-digit. In this case, it only splits it into two.

Your final table looks like the following image.