Find and Replace Line Breaks in Cells – Excel Tips and Tricks
Learn how to find and replace line breaks in cells quickly.
Here are the steps.
1) Ctrl + H
2) “Find what” press Ctrl + J
3) “Replace with” press ” ” (space)
4) Replace All
#microsoft #excel #exceltips #tips #exceltricks #tricksandtips
atoll logiciel
Amazing stuff bruv
You can also do it with SUBSTITUTE function and CHAR(10) for a new line
Very nice
Idk how much a comment means to you but thanks man this was really helpful