Excel macro to separate line-delimited values in one cell into individual cells
unmerger is an Excel macro to separate line-delimited values in one cell into their own individual cells, without breaking up the formatting of the preceeding cells in the row. Here is an example of what this macro does:
To use this function, copy the text in the .vbs file and save it as a macro in your Excel spreadsheet, then either run it from the ribbon (Developer > Macros > Run) or assign it a shortcut key.
Cells to the left of the affected cell will retain their row height and formatting. Cells to the right will also retain their row height and formatting, until three empty cells in a row are passed; then all subsequent cells will take on the row height of the affected cell. That value can be adjusted by changing the line Do Until empties > 2 to replace 2 with the maximum number of adjacent empty cells, minus 1.