Split Column by Digit to Non-Digit in Excel 2016

[Gos-C]

Hello,

I have a column with quantity having the unit of measure tacked on to it:

Column1
25g
50g
100g
25g
100g
100ml
25g
25g
25g
100g
10g
1kg

I can easily split the quantity and unit of measure, in Excel for Microsoft 365, using:

= Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByCharacterTransition({"0".."9"}, (c) => not List.Contains({"0".."9"}, c)), {"Column1.1", "Column1.2"})

However, when I use the same M code in Excel 2016, it does not work.

Any help, please.

Thanks,
Gos-C

 

[Gos-C]

I found my answer:

Separate Values and Text in Power Query

 

[Sufiyan97]

Given that the OP posted in the Power Tools forum

Sorry, did not aware of that, I need to be careful before commenting.