| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pulling out info. seperated by a comma
I have an address in one cell. I would like to seperate
the address into multiple cells at the point of each comma. This way, for example, the state, and the city would be in two cells instead of one.????? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pulling out info. seperated by a comma
Select the column and do Data=Text to Columns and select the comma as the
delimiter. -- Regards, Tom Ogilvy "scrabtree" wrote in message ... I have an address in one cell. I would like to seperate the address into multiple cells at the point of each comma. This way, for example, the state, and the city would be in two cells instead of one.????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comma Seperated File | Excel Worksheet Functions | |||
| comma seperated file import | Excel Discussion (Misc queries) | |||
| How to split a value seperated by comma? | Excel Discussion (Misc queries) | |||
| Combine names seperated by comma | Excel Discussion (Misc queries) | |||
| Problem with comma seperated list | Excel Programming | |||
![scrabtree[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
