View Single Post
  #2  
Old May 28th, 2010, 05:55 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default How do i hide carriage returns?

Format the cells to Wrap Text.

Or get rid of the linefeeds.

EditReplace

what: ctrl + j

with: space or nothing.


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 09:41:01 -0700, TVGuy29
wrote:

How do i hide carriage returns? (the "boxes" behind a line of text)