need help on delimited
 

i had a excel workbook with few thousand lines of address

a

1 Bamboo Green|177 Tran Phu St., ||Da Nang City|Tel: (84-511)
822722, 830412
2 Green Park|48 Tran Nhan Tong St., |Hai Ba Trung Dist., |Ha
Noi|Tel: (84-4) 8227725

i need to seperate it out and get rid of the delimited "|"
into something like this

a b
c d e
1 Bamboo Green 177 Tran Phu St.,
Da Nang City Tel: (84-511) 822722, 830412
2 Green Park 48 Tran Nhan Tong St., Hai Ba Trung Dist., Ha
Noi Tel: (84-4) 8227725

please help with some vba code or marco to achieve this
thanks very much,
Chuong Nguyen

need help on delimited
 

Have you tried Text-to-Columns?

Select your column of text entries

From the Excel main menu:
<data<text-to-columns
Check: Delimited.............[Next]
Check: Other and enter | in the box....[Next]
Click [Finish]

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Chuong Nguyen" wrote:

i had a excel workbook with few thousand lines of address

a

1 Bamboo Green|177 Tran Phu St., ||Da Nang City|Tel: (84-511)
822722, 830412
2 Green Park|48 Tran Nhan Tong St., |Hai Ba Trung Dist., |Ha
Noi|Tel: (84-4) 8227725

i need to seperate it out and get rid of the delimited "|"
into something like this

a b
c d e
1 Bamboo Green 177 Tran Phu St.,
Da Nang City Tel: (84-511) 822722, 830412
2 Green Park 48 Tran Nhan Tong St., Hai Ba Trung Dist., Ha
Noi Tel: (84-4) 8227725

please help with some vba code or marco to achieve this
thanks very much,
Chuong Nguyen

need help on delimited
 

See answer in programming group.


Gord Dibben MS Excel MVP

On Sun, 20 Aug 2006 10:56:27 -0700, "Chuong Nguyen"
wrote:

i had a excel workbook with few thousand lines of address

a

1 Bamboo Green|177 Tran Phu St., ||Da Nang City|Tel: (84-511)
822722, 830412
2 Green Park|48 Tran Nhan Tong St., |Hai Ba Trung Dist., |Ha
Noi|Tel: (84-4) 8227725

i need to seperate it out and get rid of the delimited "|"
into something like this

a b
c d e
1 Bamboo Green 177 Tran Phu St.,
Da Nang City Tel: (84-511) 822722, 830412
2 Green Park 48 Tran Nhan Tong St., Hai Ba Trung Dist., Ha
Noi Tel: (84-4) 8227725

please help with some vba code or marco to achieve this
thanks very much,
Chuong Nguyen