Thread: separate string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rick Rick is offline
external usenet poster
 
Posts: 334
Default separate string

I have a column of characcters which are part of an address. The format is
"General" and it looks as follows. "Calgary, T2E 6P2". Can I build a formula
that will separate the city from the postal code and put everything into 2
new columns. (The "T2E 6P2" is the postal code).