Excel formula to grab a postcode from an address

Had some addresses of the type below and want to grab the postcode from them, so created the following Excel formula :

Unit L39, Lower Mall, Arndale Shopping Centre, Manchester M4 3AQ

=RIGHT(C877;11-FIND(" ";RIGHT(C877;11)))

Returns: M4 3AQ

• Tips Blog
• 6th Sep, 2013
• Comment