Creating a column with just data before comma in another column
I have a spreadsheet with many records. One column has city then comma and
state and zip. I need to have a column with just city. Tried saving as text
file but the quotes prevented me from pulling just what was before the comma.
Help
|