3 quick ways to remove line breaks in Excel 2016 - 2007

[@mahendermbahr]

Thanks a lot. Appreciate your help on this. I was breaking my head thinking how I can remove line breaks. This really helped me.

[@9202100810]

Pretty easy and useful. Thank you worked like a charm

[@joes250]

thank you. i was about 100/2000 entries into manually changing these before i found this video!

[@selimunver20]

Amazing, i have searched for a solution on google, couldnt find any. This has saved me so much time...

[@oscarguzman8987]

exactly what i was looking for!

[@muhammadzeeshan9014]

Thanks it helped me with line breaks. BRAVO !

[@lusayuri]

Thank you very much!!

[@ukietechmanagement9314]

BEST EXPLANATION!!!! Thank you.

[@gacosta153]

Thank you!
This helps

[@chlnsgang4384]

Thank you so much subscribed :)

[@azaruddinshaikh4220]

Excellent this saves so much time..👍

[@epca_aq6511]

Very nice.

[@DDDEEPAKchoudhary]

Thank you 🤗

[@khunpatou]

Thank you so much

[@HaythamSAtia]

Thank you very much! you're brilliant!

[@chandanbera2918]

Great Video

[@helenporter8269]

Awesome!

[@helenporter8269]

Flipping marvellous!

[@MrDovanele]

saved my life...

[@Z0MB0Y]

CLEAN! Argh!!
I should have looked here before...
Thank you! :)

[@followingfulfillment6926]

really clear, thanks!

[@everyinfochannel]

thanks

[@rajatsharmaktt]

Thanks a lot it Helped :)

[@boopathy4]

there is a error using the find and replace method, " we Couldn't find the anything to replace. Click Options for more ways to search." But formula method is working. how to resolve this?

[@doubled2cze916]

yeees thank you so much

[@justintorc]

For the CTRL + J part, how do you do this function on a mac computer?

[@AristarcoPalacios]

Same here. Doesn't give the forced line break.

[@lisarevel4765]

THANK YOU!

[@tuleshray4374]

Thank you:)

[@faustin289]

What if your excel sheet contains more than a hundred columns and you don't know which one contains these dreadful non-printing characters? How then do you apply the CLEAN or SUBSTITUTE function to the whole sheet?

[@anilwasnik3277]

Gr8... lot of thanks.

[@MarnixLameijer]

Somehow the Replace funtion can't find the line breaks. The substitute functions sort off works, but when I then copy and paste as values, Excel introduces the line breaks again so it does not work. The Clean function is the only one that works for me.

[@manarzamrik3978]

Thanks!

[@HariHaran-fu3oj]

Amazing

[@zf7678]

Using Excel on a Mac nothing happens with Ctrl +J

[@Ablebits_com]

Hi! Mac has its own shortcuts. [Ctrl+J] is for Windows. For Mac it's [Cmd + Option + Return] or [Control + Option + Return]

[@MegaNitesh1992]

Thanks

[@behrouzkaramouz7600]

Thank you ❤️❤️❤️

[@alefbacomputer5185]

Thanks