Splitting data

I need to split data into 2 columns.

For instance...

City, state 29785
city, state 29767
city, state 29719



I need the zip codes to be pushed to the next column, to column 'D' to be exact. I already tried using the "text to columns" function. I selected "delimited" file type and used "2". it pushed the data to the next column everytime there was a 2. The problem is, there are 2's in the middle of the zip code sometimes. Also, it gets rid of all the 2's. Also, I can't use the "fixed width" option because there are some city/states that have more letters in them obviously, so the column is not a perfect width, if that makes any sense. Any help would be greatly appreciated as this is a column with 6,062 rows so it will be tough and tedious to do it all by hand.