I have a spreadsheet that has some cells with comma delimited text (see below) in it that I am trying to break apart into a form that will be more suitable for Access entry. I have tried to do this with the Text to Column feature but it requires a lot of cuttting and pasting because there are so many rows. Is there a way to do this with VBA?
Thank you,
Michael Armstrong
Original form:
Text1 Item1 OtherItems
Text2 Item2, Item3, Item4 OtherItems
Text3 Item5, Item6 Other Items
convert to:
Text2 Item2 OtherItems OtherItems
Text2 Item3 OtherItems OtherItems
Text2 Item4 OtherItems OtherItems
Text3 Item5 OtherItems OtherItems
Text3 Item6 OtherItems OtherItems
Thank you,
Michael Armstrong
Original form:
Text1 Item1 OtherItems
Text2 Item2, Item3, Item4 OtherItems
Text3 Item5, Item6 Other Items
convert to:
Text2 Item2 OtherItems OtherItems
Text2 Item3 OtherItems OtherItems
Text2 Item4 OtherItems OtherItems
Text3 Item5 OtherItems OtherItems
Text3 Item6 OtherItems OtherItems