Here a variation

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