Text distribution conversion puzzle

T

Tim Lyons

I have a text file with lines that look like this
abcd ijk,jkl,klm
cde ik
defg il,jl

and I want to convert it to look like this

abcd ijk
abcd jkl
abcd klm
cde ik
defg il
defg jl


Can anyone suggest how I could do this, using e.g. Word or MS excel (or
if you must MS access) i.e. can it be done without programming.


(And conversion the other way round will eventually be handy too.
TIA
Regards,
Tim.
 
J

JoAnn Paules [MVP]

I'd copy the first line and paste it in two more times. Then I'd edit the
second part of all three lines. (I know, that's not the way you wanted to do
it but it works.)
 
Top