How do I remove new line characters from a cell?(cathyc)
 

First: Please use this part (message/body) to post your question, and not the
subject line. Subject lines are meant to be brief, and give a general idea.
Also, if you leave the body blank, it will cause an error in the web server,
and we can't reply.

Second:
In answer to your question, try using the CLEAN function.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

How do I remove new line characters from a cell?(cathyc)
 

Without formulas...............

EditReplace

What: CTRL + j

With: space or nothing


Gord Dibben MS Excel MVP

On Mon, 13 Jul 2009 13:07:01 -0700, Luke M
wrote:

First: Please use this part (message/body) to post your question, and not the
subject line. Subject lines are meant to be brief, and give a general idea.
Also, if you leave the body blank, it will cause an error in the web server,
and we can't reply.

Second:
In answer to your question, try using the CLEAN function.