Thread: split post code (zip code) out of cell that includes full address
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
  
Posts: 1,071
Default split post code (zip code) out of cell that includes full address
If the first cell is A2, place this formula in B2 and drag it down. HTH
Otto
=Right(A2,7)
"Concord" wrote in message
...
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


Reply With QuoteReply With Quote