How to remove line breaks in Excel (3 Ways).

Here you will quickly learn how to remove line breaks in Excel by using 3 methods that removes all occurrences of line breaks.
1- Using Find and Replace method to remove line breaks
In this method after placing cursor in Find What, press CTRL+J to bring line break character (shown as blinking dot) then press Replace all.
2- Using Clean function
3- Using Substitute function - In this char(10) which is represents line break character is used in second parameter.
=====================================================
-Click below link to subscribe channel and stay tuned with latest uploads.
-Channel link
If liked this video then please subscribe,like and don't forget to click bell icon.
Make comment about your views, any suggestion or video topic you like to see.
=====================================================
Websites
=====================================================
You can watch and learn from below videos also.

[robertcopeland]

Never even knew about the Clean function! Thank you!