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

Creating a column with just data before comma in another column
 

=LEFT(A1,FIND(",",A1)-1)
assumes city/state/zip data is in A1.
---
Ian
--
"Help with text manipulation" <Help with text
wrote in message
...
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

Creating a column with just data before comma in another column
 

DataText to ColumnsDelimited by commaFinish.

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

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