Thanks so much if anyone can help me.
I have a 5000 line spreadsheet of product descriptions that are 6 to 8 inches long. I need to split the data into cells that are only 3 inches wide and effectively split the text into 2 or three cells depending on text length. I've been able to figure out how to do it but it will chop the words up where it splits.
Does anyone know how to do this without chopping the words that end up at the split? Meaning, if the entire word cannot fit in the cell then it will be moved to the next cell.
Thanks again for any help.
I have a 5000 line spreadsheet of product descriptions that are 6 to 8 inches long. I need to split the data into cells that are only 3 inches wide and effectively split the text into 2 or three cells depending on text length. I've been able to figure out how to do it but it will chop the words up where it splits.
Does anyone know how to do this without chopping the words that end up at the split? Meaning, if the entire word cannot fit in the cell then it will be moved to the next cell.
Thanks again for any help.