Remove the paragraph space.

i have typed 2-3 lines in a cell using Alt+Enter.

How I can remove this paragraph space as there are many cells like this.

Please help.

Thanks in anticipation.

s karan

open the Visual Basic Editor and add the macro below to a code module.
Select the cells where you wish to remove the Alt+Enter
execute the macro

Please Login or Register  to view this content.