Victor's Blog

Live as if you were to die tomorrow. Learn as if you were to live forever

NAVIGATION - SEARCH

Find/Replace Carriage Returns in Excel?

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! :)

blog comments powered by Disqus