Originally Posted by
jasono
Problem is multiple information is contained in cells, separated by the carriage return symbol. All data is contained in columns A-M. The multi-cell data is in columns J-M.
Can anybody help me with some code that will put any value after the carriage return symbol into a new column, and keep the values in A-I the same?
But your example workbook says that you want the multi-data cells to be put into new rows, not columns. The following code assumes you mean new rows, as shown in your workbook. Try it on a copy of your workbook.
Note that the "^" character separating the data in the multi-data cells is exactly that literal character, not a carriage return character (CR, ASCII 13). If this separator really is the CR character in your data, just change the 2 occurrences of "^" in the code to vbCr.
Bookmarks