Cell format for Canadian postal codes
Good One!
Alan.
"daddylonglegs" wrote in message
...
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?
|