I want to get rid of all the carriage returns in my cell. How do I do this?
Place the cursor in the 'Find what' field and use the keyboard shortcut – Control + J (hold the Control key and press the J key). You may not see anything, but this puts the line break character in the 'Find what' field. In the replace field, enter a comma followed by a space character (, ) Click on Replace All.
Changing =SUBSTITUTE(A1,CHAR(10),"") to =SUBSTITUTE(A1,CHAR(10)," ") will replace all carriage returns with a space.
=CLEAN(A1)
Clean removes all nonprintable characters from text. -- Excel Help Documentation
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With