Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
separate data from one cell
How can I separate the address field like...
[Room 825, Star House, 3 Selisbury Road, Tsimshatsui, Kowloon] all this type in one cell, and I want to divided them into 4 parts... 1. Room 825, Star House 2. 3 Selisbury Road 3. Tsimshatsui 4. Kowloon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
separate data from one cell
Provided the address is always separated by a comma, just use the Data\Text to Columns feature in Excel, selecting a delimited souce with comma as the delimiter -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=560966 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
separate data from one cell
HI
MallyCat is right using Excel to split the data in the sheet is best, but if you need to use VBA checkout the split function which splits text into a zero based array which you can then work with. Regards -- Tony Green "Mallycat" wrote: Provided the address is always separated by a comma, just use the Data\Text to Columns feature in Excel, selecting a delimited souce with comma as the delimiter -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=560966 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
separate address data in a cell | Excel Discussion (Misc queries) | |||
Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
Split data from one cell to two separate cells | Excel Worksheet Functions | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) |