Data import or transposing...

[Iceblue]

Hi all,

I have a some data in a text file in the form of "Data1-Data5" which I need
to turn into "Data1,Data2,Data3,Data4,Data5". is this something I can do
using excel, I can't seem to see if it is possible. I can import delimited by
"-" by this only gives me "Data1,Data5" and not all the others in between.

Also the data may be in the form "Data1-5" which I also need to expand as
before.

I am only a basic excel user, but would like to work this out.

Thanks in advance

Martin

 

[Shane Devenshire]

Hi,

There is nothing built into Excel to do that. You could create a VBA
program to do it.

For us to help you would need to be specific - are these the only two ways
the data would be laid out, are there other numerical values within the
"Data" such as AR1TY1 - AR6, how large can the numbers be
Data1-Data123456789?

 

[Iceblue]

Hi Shane,

Thanks for your reply. The data form can be upto 4 or 5 letters followed by
upto 3 digits, but could be a combination of all. In "AB1-AB5" the letters
will allways be the same.

example file

A1,A3,A5,A6-A9,A10
B50,B52,B53-70,B75
ABCDE1-ABCDE6
A500-607,608,609

A real file maybe just a couple of lines or maybe a 100 lines or so.

The idea is to "expand" all this data and then check for duplicate entries.

Thanks for any ideas

Martin