Text to columns Text to columns is another handy function when you have data all crammed into one cell, and you need to split it into separate columns.