View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mmcstech mmcstech is offline
external usenet poster
 
Posts: 5
Default Cell format for Canadian postal codes

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?