<div>
Use function Clean(Column)<br />
It will remove all non-printing (including new line) characters from cells
</div>


Use function Clean(Column)
It will remove all non-printing (including new line) characters from cells

<div>
go to &quot;Search&amp;Replace&quot;, in &quot;Search&quot; cell hold Alt and type 010 on numeric keyboard and hit &quot;Replace all&quot;
</div>


go to "Search&Replace", in "Search" cell hold Alt and type 010 on numeric keyboard and hit "Replace all"

<div>
Alt + 0010<br />
Alt and type 010<br />
<br />
When i click Alt and do this no numbers are entered<br />

</div>


Alt + 0010
Alt and type 010

When i click Alt and do this no numbers are entered


<div>
Hence the second line of my suggestion, &quot;No characters will appear&quot;.<br />
<br />
Thanks<br />
Rob H
</div>


Hence the second line of my suggestion, "No characters will appear".

Thanks
Rob H

<div>
Sorry but the Alt method did not work<br />
<br />
wobbled<br />
How can execute this<br />
&nbsp;I placed this in a module and ran but seems to open the macros run prompt<br />

</div>


Sorry but the Alt method did not work

wobbled
How can execute this
 I placed this in a module and ran but seems to open the macros run prompt


<div>
Can you upload a sample file? Maybe it is a different character putting the line feed in. 
</div>


Can you upload a sample file? Maybe it is a different character putting the line feed in.

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
How can i remove all Enter lines within a cell<br />
<br />
Alt + Enter is done in many cells in a colum. need to remove all in the colum K<br />
How can i do this<br />
<br />
thanks
</div>
</div>


Hi All,

How can i remove all Enter lines within a cell

Alt + Enter is done in many cells in a colum. need to remove all in the colum K
How can i do this

thanks

How can i remove all Enter lines within a cell

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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