Split Cell by Delimiter, Move to New Row...

This is a cross post to this post on this site

I'm prepping this file to be pushed through mail merge. The sheet has 25,213 rows.

Column K contains a long string of character (for the purposes of my project the field is called Subjects) and $ used as delimiters (approx 70 or as few as 1). This column needs to be split apart by $ and the separate Subjects that result from splitting apart by $ needs to be placed on a separate line. Once each Subject is on a separate line, all of the Subjects need to be lined up in Column K, one under another (the obvious result at this point is GREATLY increasing the number of rows in the sheet). Next, on the next row, column B row 2 (and all rows until an original row is found), the words "See also " followed by the entry in the original row of column K and subsequently followed by the last 4 characters of the original row of column F.

I really need help. I will be grateful if somebody can help me.

lctest1.xls is the before of a snippet of the data
lctext3.xls is the after of the same snippet of the data

THANK YOU!!!

Try with this macro:

Please Login or Register  to view this content.

Regards,
Antonio