Скачать или смотреть How to remove line breaks in Excel in one shot

How to remove line breaks.
A friend of mine was getting married, and his father needed address in an Excel sheet, where the Address line 1, line 2, .. are separated column-wise.
But while entering data, he had entered the entire address in a single cell, with line breaks using Alt + Enter.
Now it would have been a huge task to delete the line breaks manually in each address!

So he sent me his Excel file and i used this awesome trick to replace the line breaks with # key and then split the data using text to columns.

In Find & Replace, Ctrl + J works as a line break. So in Find What, i entered Ctrl + J and replaced it was a #.

Then, used Text to Columns to split the data into multiple columns.

SUBSCRIBE NOW!
   / @excelrush  

Click this link to learn more awesome functions in Excel
   • Learn Excel's Tricks  

Click this link to learn how to manage your personal finance using Excel
   • Personal Finance