Replacing Enters in Excel

I had just a week ago this case, my Excel had a cell containing 4 codes separated just by enters.Excel and other Microsoft Office applications have an option to replace any kind of text, but what happen if you want to replace no-printable characters like enters.

I had just a week ago this case, my Excel had a cell containing 4 codes separated just by enters.

 
Text with line breaks in one cell
 

Then, to have this codes separate by "-" I decided to replace the enters, to do this was necessary to enter this character in the "Search" textbox, this is possible by typing "Alt + 0010" and a "." is shown flashing, after that I put the "-" which was the replacement.


Use the replace function in Excel
 
 
See the line breaks gone

Finally I got my objetive, a tip to bear in mind is that to put the enter character it's necessary to type 0010 with the numeric pad. Otherwise, nothing will happen.
 

Comments

Popular posts from this blog

I Need to Send an Automatic Email with Lotus Notes

Turn Horizontal Visio Swimlanes into Vertical Ones

Install TWRP Recovery in Xiaomi Redmi 6A