Split a Column into 2, use a character limit that does not cut words in half.

[vishesh10667]

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

 

[mboo86]

If you still need help, can you give the sample data with XL2BB so that I can be sure I am testing with exactly what you have?

Hi Peter, thanks for getting back to me. Managed to find a quick fix for the issue of repeating full addresses. Some of the entries had double spaces in them I found causing the issue. So what I did was ran the text column with a =TRIM and that solved the issue! I'll reach out to you if I run into any other trouble. Bless you and thank you for your guidance.

 

[millawitch]

For someone on Microsoft 365, have a look at my post here.

Hope it helps!