Many a times, you have a lot of line breaks in your cells, and it gets extremely difficult and time consuming to rearrange all the data in a single cell. You may have a list of thousand names or a list of 5000 addresses which you want to rearrange.
Use this simple method to remove the line breaks and rearrange everything in no time!
For more videos to learn excel, click this link
• Learn Excel's Tricks
SUBSCRIBE!
/ @excelrush
Blog
Visit www.ExcelRush.com for the free blog to learn Excel in-depth.
Rushabh Shah is an expert in training Professionals & Students in Excel's Advanced features & formulas. These tutorials are simply a way to spread the knowledge and make people more productive using Excel.
For Classroom & Online Live Trainings with Rushabh, visit www.DLTC.co