Excel CLEAN Function Example - Remove Line Breaks in Excel

In this video we use the CLEAN function to remove line breaks from a range of cells in Excel. Excel has many useful Text functions that help us to manipulate and cleanse data. The CLEAN function remove non-printable characters from a cell. http://www.computergaga.com/27-excel-hacks-to-make-you-a-superstar.html The most common use of CLEAN is to remove line breaks. This example is demonstrated in the video. Find more great free tutorials at; http://www.computergaga.com Connect with us! Google+ ► https://plus.google.com/+Computergaga Facebook ► http://www.facebook.com/computergaga Twitter ► http://www.twitter.com/computergaga1