Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!* |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove the last 4 characters within a cell | Excel Discussion (Misc queries) | |||
How do I remove new line characters from a cell? | Excel Discussion (Misc queries) | |||
Remove Characters from a cell | Excel Worksheet Functions | |||
remove non-numeric characters from a cell | Excel Discussion (Misc queries) | |||
remove last three characters of cell | Excel Discussion (Misc queries) |