WOW oh WOW; THANKS COOL. I have 1300 rows to treat this way and it works.
Thank you.

"FSt1" wrote:

hi
this might work for you...
for calgary...
=LEFT(B7,FIND(",",B7,1)-1)
for the postal code
=RIGHT(B7,FIND(",",B7,1)-1)

adjust the cell refererce as needed.
the formula assume that the city and postal code are seperated by a comma.
if that is not true each time then adjustment may have to be made.

Regards
FSt1
"Rick" wrote:

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).