or use this formula

=REPLACE(A1,4,0," ")

"Jim Thomlinson" wrote:

I don't think you will have too much luck wht a format since the cell
contents will be text. You can however just insert a column and ust the
following formula...

=LEFT(A1, 3) & " " & RIGHT(A1, 3)
--
HTH...

Jim Thomlinson


"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?