![]() ![]() ![]() Check next to Other and, in the blank box next to it, hit Ctrl + J.Go to the Data tab and click Text to Columns.Notes Split Text based on Carriage Returnīasically, we use Text-to-Columns with Ctrl + J as the delimiter to tell Excel to split data based on the individual lines within a cell. (Carriage return is the term for the element that puts text onto a separate line within a cell in Excel.) Technically, this method is Text-to-Columns using a carriage return as the delimiter. How to split a cell by each line of data within it this will put each line into its own separate cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |