There is no format for Canadian Postal Codes.

Assuming codes are Column A

Insert a new column to the right of column A

In B1 enter this formula.

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

Double-click the fill handle to copy down 27k rows.

When happy, copy and paste specialvaluesokesc.

Delete original column A


Gord Dibben MS Excel MVP

On Fri, 5 Jan 2007 15:01:01 -0800, mmcstech
wrote:

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?