View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Help with text manipulation Help with text manipulation is offline
external usenet poster
 
Posts: 1
Default 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