• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • Last Modified:

Excell to extract zip code / post code

In a spreadsheet, the last digits in a call i a zip code / post code.

Is there some way of telling Excell to copy across the last  digits of a cell content?
0
Mawallace
Asked:
Mawallace
  • 2
1 Solution
 
barry houdiniCommented:
Are they UK postcodes?

If you have an address in A2 with the postcode at the end then this formula should extract the whole postcode

=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",9)),20))

regards, barry
0
 
Patrick MatthewsCommented:
US codes?  Canada?  UK?  Other?

A sample file would be helpful :)
0
 
MawallaceAuthor Commented:
Uk
0
 
barry houdiniCommented:
Hello Mawallace, did you try my suggestion?

If you have an address in A2 with the full postcode, e.g.

10, Downing Street, London, SW1A 2AA

then the formula I suggested above in B2 will give you just the postcode, i.e. SW1A 2AA, is that what you need or something else?

regards,. barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now