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.
Click this link to learn more awesome functions in Excel
Click this link to learn how to manage your personal finance using Excel
Tags: How to remove line breaks in Excel in one shot, Excel, Excel Tutorial, Remove line breaks in Excel, remove line breaks, delete line breaks, text to columns, line breaks remove, line breaks delete, separate data from single cell to multiple cells, quick ways to remove line breaks in Excel, Easily remove line breaks in Excel, how to remove line breaks in Excel in one shot, remove line breaks in one shot, remove line breaks in excel column, excel tutorial for beginners, excel formulas and functions