separate data from one cell

[Sandy]

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

[Mallycat]

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

[ADG]

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