Extract text before multiple delimiters|Power Query|Excel Forum|My Online Training Hub

Hi Bunmi,

You can split the column by delimiter (space) from the right, then do it again

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Name", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Name.1", "Name.2"}),
#"Removed Columns" = Table.RemoveColumns(#"Split Column by Delimiter",{"Name.2"}),
#"Split Column by Delimiter1" = Table.SplitColumn(#"Removed Columns", "Name.1", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Name.1.1", "Name.1.2"}),
#"Removed Columns1" = Table.RemoveColumns(#"Split Column by Delimiter1",{"Name.1.2"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns1",{{"Name.1.1", "Name"}})
in
#"Renamed Columns"

Regards

Phil