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
 

You should be able to use Data | Text to Columns for this. Choose the "|"
as the delimiter and that will split the data up and lose the "|"

Regards

Trevor


"Chuong Nguyen" wrote in message
...
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
 

Data Text to Columns

Tim


"Chuong Nguyen" wrote in message
...
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
 

Try DataText to ColumnsDelimited byOther. Enter a | (pipe) and Finish

Make sure you have a few blank columns to the right of your original column.


Gord Dibben MS Excel MVP

On Sun, 20 Aug 2006 10:56:22 -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