Here a variation
PHP Code:
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
pCode = Table.AddColumn(Source, "Postcode_", each Text.AfterDelimiter(Text.Trim([Fulladdress])," ",{1, RelativePosition.FromEnd})),
replace = Table.ReplaceValue(pCode,each [Fulladdress],each Text.Replace([Fulladdress],[Postcode_],"") ,Replacer.ReplaceValue,{"Fulladdress"}),
result = Table.RemoveColumns(replace,{"Postcode"})
in
result
Bookmarks