Thread: formula for Canadian Postal Codes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LB LB is offline
external usenet poster
  
Posts: 5
Default formula for Canadian Postal Codes
Hi there. Can someone help me out with a formula to go from this:
b3k2m6

too this:
B3K 2M6

capitals included?

I have them all in one column, G.
Thannks.


Reply With QuoteReply With Quote