Have a spreadsheet of names and addresses. Some address in the column have
"city, state zip". Already have city and zip in next 2 columns for those
entries. I just want to remove everything in the cells to the right of and
including the comma.

Some citys are 2 or 3 words.