I have a spreadsheet with several cells that contain several pieces of data separated by Alt+Enter. I have already submitted and received a solution for how to split the cell contents to new rows containing single values here:
http://www.excelforum.com/excel-prog...-new-rows.html
The problem I am having is that several of the cell contain an Alt+Enter at the end of the line which is causing extra rows to be produced when the marco is run.
I need a macro to remove only the Alt+Enter at the end of the data in each cell, but keep the other Alt+Enter's that are between text in place.
I did find a way to do it by reproducing the entire spreadsheet with the formula
=if(right(a1,1)=Chr(10),left(a1,len(a1)-1),a1)
and then copy - paste special - values
I could record this as a macro, but it seems like there should be an easier way to do it using a macro.
Thanks!
Bookmarks