Скачать или смотреть Line break within a cell as delimiter for Excel's Text to Columns tool

You may come across situations where you need to use a line break as the delimiter in Text to Columns in Excel. A line break is where, within a single cell, text appears on two separate lines.

Unlike the situation with unrecognised spaces though, there is no character to copy and paste into the Text to Columns.

For images see blog post : https://www.auditexcel.co.za/blog/lin...
------------------------------------------------------------------------------------------------------------------------------------------------------

✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/

------------------------------------------------------------------------------------------------------------------------------------------------------
00:00 Line Breaks (separate lines within the same cell)
00:30 Splitting text into columns based on where the line break is
01:30 Use CTRL Shortcut to 'create' the line break character

For images see blog post : https://www.auditexcel.co.za/blog/lin...


Identifying a Line Break in Excel cells
A line break is obvious when you click in a cell. As shown below, when you click in the cell, the cell looks like it is on 1 line but when you look in the formula bar it is actually on 2 lines (which implies that there is a line break character at the end of the first line).

Occasionally you will only see the one line in the cell, but when you click on it and expand the formula bar you will see other information.

Split the column using this line break
The only trick is that you need to use a shortcut to ‘create’ the line break character using CTRL + J.

As shown below you go through the normal Text to Column steps (click on DATA ribbon, Text to Column button, then choose Delimited and Next).

he trick is in the next screen. Choose the Other option, and while clicked in the input box, hold CTRL down and push your J button. Immediately the data preview window will show that it recognises the line breaks and will split the column based on the line breaks it sees.
You can now continue as normal with your Text to Columns.