添加自定义列并键入：

Splitter.SplitTextByCharacterTransition({"A".."Z", "a".."z"}, {"0".."9"})([Column1]){0}

如何添加列，自定义列，带公式

= Text.Range([Column1],0,Text.PositionOfAny([Column1],{"a".."z","A".."Z"})+1)

我不认为您真的搜索了此内容。It's in Microsoft's documentation.
我从你的清单开始：

12345A123
23456B000
45678D93

然后我点击"转换"，"分割列"，然后"非数字到数字"。作为最后一步，我删除了分割产生的第二列。

以下是输出：

12345A
23456B
45678D

下面是M代码：

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Character Transition" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByCharacterTransition((c) => not List.Contains({"0".."9"}, c), {"0".."9"}), {"Column1.1", "Column1.2"}),
    #"Removed Columns" = Table.RemoveColumns(#"Split Column by Character Transition",{"Column1.2"})
in
    #"Removed Columns"