| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
split post code (zip code) out of cell that includes full address
=RIGHT(A1,7)
Copy down. Gord Dibben MS Excel MVP On Thu, 15 Oct 2009 09:28:14 -0700, Concord wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need code to copy and paste based on cell address. | Excel Discussion (Misc queries) | |||
| Post Code | Excel Worksheet Functions | |||
| Post code lookup | Excel Worksheet Functions | |||
| VBA code to locate cell address of AutoFilter dropdown box | Excel Discussion (Misc queries) | |||
| Post code & Suburbs | Excel Discussion (Misc queries) | |||
Hybrid Mode
