Excel sheet comprises 1000+ records where each address occupies a single cell
e.g.
21 Select Avenue, London, SW3 5PX
31 Shaftsbury Drive, Stanley Park Estate, Liverpool, LP5 6EW

want to extract post code only into a separate cell.
Effectively want 'parse' the last 7 characters (including space).
Any advice/guidance greatfully received

Concord