Hello all,
I've been trying to find a way to seperate multiple columns of delimited test (by '; ') into new rows, with no luck what so ever, I have been able to run the macro on one column, but not multiple columns. Is this at all possible.
I have 4 regular text columns and 6 delimited columns, the 4 regular columns are being replicated fine, the first of the delimited columns are fine, but then the last 5 delimited columns just get replicated into the new cells caused by the first split.
I have attached the workblook I've been using, any suggestions would be greatly appretiated.
Thanks
DWTK
Bookmarks