Forum Discussion
Extracting Post Code from address e.g. HU17 0RT
How do extract and move the post code to next door cell from the following situation:
| Heron Buildings Plaxton Bridge Road Woodmansey BEVERLEY East Riding of Yorkshire HU17 0RT |
| 310 Hull Bridge Road Tickton BEVERLEY East Riding of Yorkshire HU17 9RT |
| Home Farm Boynton BRIDLINGTON East Riding of Yorkshire YO16 4XJ |
| High Street Carlton GOOLE East Riding of Yorkshire DN14 9LY |
| 17 The Butts Little Weighton COTTINGHAM East Riding of Yorkshire HU20 3XD |
2 Replies
Perhaps
=RIGHT(A1,8)
- Works! Brilliant, just what I needed.
Thank you
