Split in Power Query

[srehman]

AS123456 Split only starting Alphabet (AS) & (123456) or separate number & alphabet in 2 columns

AMRP2541 Split only starting Alphabet (AMRP) & (123456) or separate number & alphabet in 2 columns

 

[sandy666]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Text = Table.AddColumn(Source, "Text", each Text.Select([Raw],{"A".."Z"})),
    Number = Table.AddColumn(Text, "Number", each Text.Select([Raw],{"0".."9"})),
    TSC = Table.SelectColumns(Number,{"Text", "Number"})
in
    TSC

Raw		Text	Number
AS123456		AS	123456
AMRP2541		AMRP	2541

 

[srehman]

Superb as usual

 

[sandy666]

You are welcome & thanks for the feedback

 

[alansidman]

Here is an alternative PQ solution

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Character Transition" = Table.SplitColumn(Source, "Raw", Splitter.SplitTextByCharacterTransition((c) => not List.Contains({"0".."9"}, c), {"0".."9"}), {"Text", "Number"})
in
    #"Split Column by Character Transition"