Excel Line Break after blank Space

Excel Line Break after blank Space

I have often had the requirement that after various exports, e.g. Teams Export of all guest users in a team after importing the CSV in Excel, everything is in one line.
To make it clearer, it would of course be great if each entry was in a separate line.

There is a little trick with Excel that automatically creates a line break after each space.

1.) Within your Excel Sheet open “Find and Replace” (STRG+F)
2.) In the “Replace” Tab type in the “find that” an Space
3.) in the “replace with” hold the left “ALT” Key and Type in 010
4.) After that click on “Replace all”

And now, you have an Line break after all blank space.

Comments are closed.