Text to columns with multiple rows of text in a cell

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Meggesto

Board Regular
Joined
Mar 8, 2016
Messages
216
It might take a little work but if you use the Text To Columns Tool on the Data Tab you could use a delimiter such as the space to separate all the names into respective columns. You'd have to rearrange them from that point but if a pattern emerges from how they're broken out you could write a piece of code to reorganize it by looping. Or it might be possible just to do it quickly by hand depending on the size of your list.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,573
Messages
5,469,472
Members
406,655
Latest member
pwilson06

This Week's Hot Topics

Top