Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a new list of repeating data in a column | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
Creating charts - first row&column treated as normal data | Charts and Charting in Excel | |||
Creating a column of numbers from a column with some blanks? | Excel Discussion (Misc queries) | |||
creating a date column from seperate data | Excel Worksheet Functions |