<div>
You can Format Cells-&gt;Alignment-Merge Cells, but that will delete the content of 2 of the 3 rows. You can add the data back afterward.
</div>


You can Format Cells->Alignment-Merge Cells, but that will delete the content of 2 of the 3 rows. You can add the data back afterward.

<div>
Can you find/replace on a line break? &nbsp;The clean function makes it one line, but without spaces between words.
</div>


Can you find/replace on a line break?  The clean function makes it one line, but without spaces between words.

<div>
Thanks, Martin, that does work. Though when you use the ALT button and enter 010, nothing shows up in the Find Box. But if you proceed on to the Replace and enter a space the Find/Replace works. Thanks again.
</div>


Thanks, Martin, that does work. Though when you use the ALT button and enter 010, nothing shows up in the Find Box. But if you proceed on to the Replace and enter a space the Find/Replace works. Thanks again.

<div>
You're welcome and I'm glad I was able to help.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
<br />
Marty - Microsoft MVP 2009 to 2016<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Experts Exchange MVE 2015<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Experts Exchange Top Expert Visual Basic Classic 2012 to 2015
</div>


You're welcome and I'm glad I was able to help.

In my profile [https://www.experts-exchange.com/M_258447.html] you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2016
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2015

<div>
<div class="content wysiwyg-content">
How can I get the three rows (lines) within an Excel cell to be just one row (line)? &nbsp;I have several columns formatted that way. &nbsp;Is there a function to do this?
</div>
</div>


How can I get the three rows (lines) within an Excel cell to be just one row (line)?  I have several columns formatted that way.  Is there a function to do this?

Excel 2010 Column heading has three rows in one cell. Make one row.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.