ExcelBanter - How do i hide carriage returns?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do i hide carriage returns? (https://www.excelbanter.com/excel-discussion-misc-queries/264814-how-do-i-hide-carriage-returns.html)

TVGuy29

How do i hide carriage returns?

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

Gord Dibben

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)

All times are GMT +1. The time now is 03:32 PM.