I am really struggling with this one. I have around 10 columns which looks up multiple data from another sheet and brings it back into a cell and enters a carriage return (Char(10)) between each element of data.
In another cell, i join all the data from these 10 cells. The problem is that not all 10 cells will have data in them all of the time so i need to remove any leading and trailing carriage returns from the text otherwise i get huge gaps in my data. Can I do this through a formula or vba (will need help understanding any vba)? Any help on this would be appreciated.