Canadian postal codes are letter number letter number letter number. Which
means that Santa even gets a postal code
H0H 0H0
(Not kidding... Canada Post uses that postal code for routing letters to
Santa)

--
HTH...

Jim Thomlinson


"Alan" wrote:

I'm unfamiliar with Canadian post codes, but if they all consist of six
characters, in another column
=LEFT(A1,3)&" "&RIGHT(A1,3)
and drag down to the end of the list.
Lose the formulas by right clicking the whole range Copy, right click
again, Paste Special check Values OK
Regards,
Alan.
"mmcstech" wrote in message
...
I have a large Excell spreadsheet (27k records) that includes a column for
Postal Codes (Canadian). The provider did not type the space in between
the
first and last 3 characters of the postal code. Can you tell me how /if I
can quickly format the Postal Code column to include the space?