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...
Perhaps
=RIGHT(A1,8)
- Works! Brilliant, just what I needed.
Thank you
