vishesh10667
New Member
- Joined
- Nov 26, 2019
- Messages
- 18
- Office Version
- 2007
- Platform
- Windows
Title says it all.
I have huge columns of data that can only be 30 characters long. I want to use a formula to split the column into two. The original column will have a character limit of 30, and should not cut words in half. If the Length will be more than 30 while including the entire last word of the cell, that word should be the first displayed in adjacent cell in the 2nd column.
The 2nd column should also be 30 characters long. And rest in 3 column
I usually use a Text to Columns method, but dont know how to make it not cut off the words. Any ideas?
Thanks in advance
I have huge columns of data that can only be 30 characters long. I want to use a formula to split the column into two. The original column will have a character limit of 30, and should not cut words in half. If the Length will be more than 30 while including the entire last word of the cell, that word should be the first displayed in adjacent cell in the 2nd column.
The 2nd column should also be 30 characters long. And rest in 3 column
I usually use a Text to Columns method, but dont know how to make it not cut off the words. Any ideas?
Thanks in advance