canadian postal code

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
 
B

Bernard Liengme

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
 
Top