canadian postal code

  • Thread starter Thread starter SourisVerte75
  • Start date Start date
S

SourisVerte75

Hi I need help! I want to have a personnal cells form for canadian postal
code. Is anybody can help me?
The format is
G1H 5J8 (Majletter+number+Majletter+space+number+Majletter+number)

Thank you
 
Hello,
Excel allows for the formatting of numeric data (number and dates/times) but
not text.
It A1 contains the postal code then in B1 enter =Left(A1,3)&" "&RIGHT(A1,3)
to get ANA ANA
You can now use Copy followed by paste Special to convert the formulas to
values thus allowing you to delete column A
Hope this helps
 

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

Excel Cell Formats 4
Validate Canadian Postal codes in Excel 1
Input masks in Excel 1
?Validate Canadian Postal Code 5
VBA inserting a space in a text 3
Cdn Postal Code 3
Canadian Postal Code format? 9
Deleting a Comma "," 2

Back
Top