It is caused by the cmpany name having a comma in it.

The macro is programmed to look for the last comma and assumes that it is the devider between the zip code and the company name.

If the state abbreviation of IL is the only one listed in the data to be parsed then I can change the macro to look for IL instead of the last comma.

Another option is that if there are always only 2 comma's after the CH then I could also change the macro to work off the 2nd comma after the CH