L
Lynnie
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
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