Code for random spaces for text to column in VBA

I am sorting data using a Marcros program I designed, and in the city column there is the City,State, and Postal Code. I need them seperated into seperate columns so i was using txt to column. This worked very well, until there were spaces in the Cities. For instance, it would be Yorba Linda, CA 91542. This would seperate it using spaces and the city would now be in two seperate columns when it is supposed to be in one. I can't use the fixed width because there are a lot of different city names. So what would be the best VBA code to make this work? Thank you for any help

wow, that is a great idea. I didnt even think about that. Thank you so much. thatll work perfectly