Data import or transposing...
 

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

Data import or transposing...
 

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?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Iceblue" wrote:

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

Data import or transposing...
 

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


"Shane Devenshire" wrote:

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?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Iceblue" wrote:

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