How to remove line breaks in excel

Most of the times we face the problem of line breaks in excel cells. The two ways to remove the line breaks is the 'clean' function and the 'substitute'  function. Check this video to see how to use the formulae


~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners.
Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1
Want some focused playlists. Click here and lean back:
The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe
All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401
Excel basics if you have just started: https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76

Stay connected at:
Blog: http://excelissimple.blogspot.com/
Facebook: https://web.facebook.com/excelissimple
Wonder How to: http://creator.wonderhowto.com/akhilkakroo/
Instructables: http://www.instructables.com/id/Excel-Teacher/
Twitter: https://twitter.com/akhilkakroo
Pinterest: https://www.pinterest.com/akhilkakroo/excel/
Google Plus: google.com/+excelissimplenow

Share, like and post any questions on the videos