Is there a formula/macro that will allow me to remove all carriage returns within a cell? I can't seem to remove them and I've tried a number of things to remove them. Can someone please help if they have a moment?
You can do that using the normal replace in Excel
Ctrl H > in find what Ctrl J (the box should go blank except for a small blinking dot in the bottom left) > Replace with, leave blank > OK
Make sure that the "Match Entire cells" is unchecked