Hello,

I have a .xls file with one column of 500 characters in each cell. I would
like to split up the cells into two columns, each consisting of 256
characters or less.

Currently, when I split the column into two columns, at the 256 mark it
would split a word into two parts. The first few letters of a word is at the
end of the first cell, and the last few letters is the start of the second
cell.

Ex. for the word transmission
First Cell: XXXXXXXXXXXXXX Transmi
Second Cell: ssion XXXXXXXXXXXXXXX

Is there a way for excel to split the column into two, but keeping the words
together? there are 3,000 rows.

Thanks!
Lynnie