Thread: remove comma and text past it in cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default remove comma and text past it in cell
DataText to ColumnsDelimited by commaNext

Select all columns but the City column and "do not import column"

Finish


Gord Dibben MS Excel MVP

On Thu, 25 Sep 2008 20:49:01 -0700, ~barney
wrote:

Have a spreadsheet of names and addresses. Some address in the column have
"city, state zip". Already have city and zip in next 2 columns for those
entries. I just want to remove everything in the cells to the right of and
including the comma.

Some citys are 2 or 3 words.

Reply With QuoteReply With Quote