Excel Cell Formats

  • Thread starter Thread starter Guest
  • Start date Start date
Canadian Postal Codes are Text and cannot be formatted as US Zips can be.

Assuming your postal code is in A1, in a seperate column enter this formula:

=LEFT(A1,3)&" "&RIGHT(A1,3)

You can then Copy and Paste Special>Values over the original data.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cdn Postal Code 3
Input masks in Excel 1
canadian postal code 1
VBA inserting a space in a text 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel numeric to text cell contents 1
My Cell drops the Zero if it is first. 1
Validate Canadian Postal codes in Excel 1

Back
Top