tinkerbell737
Board Regular
- Joined
- Nov 25, 2002
- Messages
- 96
I have a cell that has a comma separated value that is 354 fields long. As such, if I use the Text To Columns feature to split the data at each column, I lose several columns (because excel cannot have that many columns).
How can I break the data at the comma, but have it list in rows instead?
How can I break the data at the comma, but have it list in rows instead?