17. August 2013 17:22
Finding and Replacing Carriage Returns in Excel is easy. You don't need use VBA at all. Here is the trick:
Open the find and replace window
In the Find What: text box enter the following value ALT+0010 making sure to use the number keypad. You will not see anything appear in the textbox.
You can leave the Replace With: blank.
note: You may also have to remove the wrap setting for the cells to get it to appear as a single height cell.
Easy as! :)