adding a comma btw words in cell

[megkelley]

What function do I use to add a comma to seperate the following information in a cell?

CHICAGOIL60611

The format I need it in is Chicago, IL, 60611

Thanks!

[mudraker]

I have assumed that the lenght of thr 60611 field is always 5 charaters, The IL is always 2 characters & Chicargo is variable number of characters depending on City Name

CHICAGOIL60611 In A1
This formula in b1
=PROPER(LEFT(A1,LEN(A1)-7))&", "&MID(A1,LEN(A1)-6,2)&", "&RIGHT(A1,5)