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