Creating a column with just data before comma in another column

  • Thread starter Help with text manipulation
  • Start date
H

Help with text manipulation

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
 
G

Gord Dibben

Data>Text to Columns>Delimited by comma>Finish.

Make sure you have an empty column to the right.


Gord Dibben MS Excel MVP

On Sun, 18 Nov 2007 09:14:00 -0800, Help with text manipulation <Help with text
 
Top