Excel User Group

Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Sign in | Join | Help

All Tags » Parsing Post Codes (RSS)

Browse Site by Tags

Showing related tags and posts accross the entire site.

Sorry, but there are no more tags available to filter with.

Re: Postal Codes

And...your next question will be to get just the Postal 'Area'... PO, SO, G, M, B, etc (Data in A1) =IF(ISNUMBER(VALUE(MID(A1,2,1))),LEFT(A1,1),LEFT(A1,2))

Posted to Functions and Formulas (Forum) by Nick Hodge on Fri, Aug 8 2008

Page 1 of 1 (1 items)

Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.