ExcelBanter - How do I remove new line characters from a cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I remove new line characters from a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/236737-how-do-i-remove-new-line-characters-cell.html)

cathyc

How do I remove new line characters from a cell?

Dave Peterson

How do I remove new line characters from a cell?

The alt-enters?

Select the range to fix
Edit|Replace
What: ctrl-j (hit and hold the control key while typing j on the keyboard)
with: (leave blank or spacebar or whatever you want)
replace all

cathyc wrote:

--

Dave Peterson

All times are GMT +1. The time now is 03:54 PM.