How to remove line breaks in a cell?
Solved
Petrel63
-
Petrel63 -
Petrel63 -
Hello,
Do you know how to remove line breaks present inside an Excel 2003 cell and replace them with a space?
There is the TRIM function that removes text control characters, but it sticks the end of the previous sentence to the next one.
For example, in a cell:
"finit.
Il.."
After using TRIM: "finit.Il"; while I would like to get with a space "finit. Il" to clearly separate the sentences.
The line break is ASCII code 10. We can insert it by doing =CHAR(10), but I can't find the opposite function.
Thanks in advance to you.
Do you know how to remove line breaks present inside an Excel 2003 cell and replace them with a space?
There is the TRIM function that removes text control characters, but it sticks the end of the previous sentence to the next one.
For example, in a cell:
"finit.
Il.."
After using TRIM: "finit.Il"; while I would like to get with a space "finit. Il" to clearly separate the sentences.
The line break is ASCII code 10. We can insert it by doing =CHAR(10), but I can't find the opposite function.
Thanks in advance to you.
