remove comma and text past it in cell

B

~barney

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

Sheeloo

If your addresses are in Col A starting in A1
then type the following in B1 and copy down
=LEFT(A1,FIND(",",A1)-1)

This will remove everything from the first comma to the end...

Once you get it right you may copy col B and PASTE SPECIAL->VALUES where you
want them.
 
G

Gord Dibben

Data>Text to Columns>Delimited by comma>Next

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

Finish


Gord Dibben MS Excel MVP
 

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

deleting a comma from every cell in a column 2
Add a character in .cd file 6
alphabetize entire rows by first word of first column 5
Column mailing list needs to be converted to rows 2
Excel Spreadsheet Manipulation 21
Data Selection 2
using excel text functions (specific to strings) 7
Deleting a Comma "," 2

Top