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?