| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove comma and text past it in cell
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove comma and text past it in cell
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. "~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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract the text between last comma and last but one comma. | Excel Worksheet Functions | |||
| parse comma separated text to multiple cells and remove duplicates | Excel Worksheet Functions | |||
| find and remove a string of a cell value with comma as delimiter | Excel Discussion (Misc queries) | |||
| How to remove comma and decimals from a value | Excel Discussion (Misc queries) | |||
| Formula for adding a comma in front of text in a cell | Excel Worksheet Functions | |||
Hybrid Mode
