Posted to microsoft.public.excel.misc

mmcstech

external usenet poster

Posts: 5

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to convert a month to a quarter ......	Epinn	New Users to Excel	26	May 3rd 23 07:45 PM
Sumproduct issues	SteveDB1	Excel Worksheet Functions	25	June 3rd 09 04:58 PM
Custom functions calculating time arguments Help Desperate	Bill_De	Excel Worksheet Functions	12	April 25th 06 02:22 AM
Possible Lookup Table	Karen	Excel Worksheet Functions	5	June 8th 05 09:43 PM
can't format cell - have tried unlocking and unprotecting	griffin	Excel Discussion (Misc queries)	1	April 5th 05 02:11 AM

All times are GMT +1. The time now is 06:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us