Re: Find a carriage return in a worksheet

Giganews Newsgroups
Subject: Re: Find a carriage return in a worksheet
Posted by:  Dave Hawley (da…@ozgrid.com)
Date: 12 May 2004

Hi

Select one of the cells with the carriage return. Copy it from the
"Formula Bar" then Enter. Now select your data and go to Edit>Replace
paste in the carriage return to the "Find What" box and leave the
"Replace With" Blank

or, try using the CLEAN function. Then Copy, paste special - values.

** Posted via:http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forumhttp://www.ozgrid.com/forum ***

Replies

None

In response to

Find a carriage return in a worksheet posted by VW on Tue, 11 May 2004