Dreamer
04-27-2006, 10:20 PM
Hi all,
I want to import text file to excel, and I've got a problem ...
I've used "\" as the delimiter, but this will cause the problem for the following lines:
H \ 1 \ yes
I \ 2 \ no
J \ 3 \ no
K \ 4 \ no
N \ 7 \ yes \ no
O \ 8 \ HGK \ GHG
Indeed "yes \ no" & "HGK \ GHG" should be put together, if I divide it by "\", they will be seperated.
N 7 yes no
O 8 HGK GHG
If I only take the first 2 "\" into account, can I use macro to help this? Thanks!!
Desired Output:
H 1 Yes
I 2 No
J 3 no
K 4 no
N 7 yes \ no
O 8 HGK \ GHG
I want to import text file to excel, and I've got a problem ...
I've used "\" as the delimiter, but this will cause the problem for the following lines:
H \ 1 \ yes
I \ 2 \ no
J \ 3 \ no
K \ 4 \ no
N \ 7 \ yes \ no
O \ 8 \ HGK \ GHG
Indeed "yes \ no" & "HGK \ GHG" should be put together, if I divide it by "\", they will be seperated.
N 7 yes no
O 8 HGK GHG
If I only take the first 2 "\" into account, can I use macro to help this? Thanks!!
Desired Output:
H 1 Yes
I 2 No
J 3 no
K 4 no
N 7 yes \ no
O 8 HGK \ GHG