About CHAR and CLEAN Functions
Overview of CHAR and CLEAN
Remove Line Breaks Excel Functions/Text Manipulation | ||||||||||||
=CHAR(CodeNumber) =CLEAN(Text) CHAR Overview: Returns the character corresponding to the specified numeric code. CLEAN Overview: Removes non-printable characters, such as line breaks, from text. |
||||||||||||
|
When to Use CHAR
- To remove line breaks within a cell.
How to Use CHAR
A | B | C | D | E | |
1 | |||||
---|---|---|---|---|---|
2 | New York |
Brooklyn Downtown |
BrooklynDowntown
=SUBSTITUTE(C2, CHAR(10), "") =CLEAN(C2) Removes line breaks (CHAR(10)) by replacing them with blank spaces. |
||
3 | |||||
4 |
|||||
5 |