If your addresses are in Col A starting in A1
then type the following in B1 and copy down
=LEFT(A1,FIND(",",A1)-1)

This will remove everything from the first comma to the end...

Once you get it right you may copy col B and PASTE SPECIAL-VALUES where you
want them.

"~barney" wrote:

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.