Creating a column with just data before comma in another column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

splitting data from 1 column into multilple? 6
Finding the number of times a word is used in a range of cells 8
Returning multiple text data into 1 column from many column entrie 1
Rows to columns with multiple sets 1
remove comma and text past it in cell 2
Auto Filter Comma Dilemiation 2
Splitting Text from single cell in column across multiple Columns 3
Formatting cells to show two dates in one cell 3

Back
Top