I have data in 3 columns, which is Column I, J and K.


I need help with writing an Excel formula to ensure a column I has less than 60 characters it should remain. Otherwise, if it exceeds the 60 characters it should be moved into the other columns(J +K Columns) and no words should be split into two columns depending if the other columns does not exceed the 60 characters length. I want to same logic to be applied for columns J + K.

I'd preferably like to solve this by using a nested if function with find, right and left function and mid functions