<div>
Or using Find and Replace:<br />
<br />
In the find box press Alt and type 010<br />
In the replace type a space<br />
<br />
Thanks<br />
Rob H
</div>


Or using Find and Replace:

In the find box press Alt and type 010
In the replace type a space

Thanks
Rob H

<div>
Perfect. And I followed your advice on building in the &quot;&nbsp;&quot; (space). Thanks for your quick response...<br />
<br />
Andrea
</div>


Perfect. And I followed your advice on building in the " " (space). Thanks for your quick response...

Andrea

<div>
<div class="content wysiwyg-content">
I have inherited a large spreadsheet which contains a significant number of line breaks (using ALT + ENTER) within the cells of several columns of text. I am looking for a macro or automated way to remove all line breaks within cells so that the text wraps properly. I couldn't find anything in the &quot;Find &amp;&nbsp;replace&quot; feature to address this...<br />
<br />
Thanks!<br />
Andrea
</div>
</div>


I have inherited a large spreadsheet which contains a significant number of line breaks (using ALT + ENTER) within the cells of several columns of text. I am looking for a macro or automated way to remove all line breaks within cells so that the text wraps properly. I couldn't find anything in the "Find & replace" feature to address this...

Thanks!
Andrea

Automated way of removing line breaks within a cell in Excel

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

Microsoft Excel

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.