Columns should not exceed the 60 characters and no words should be split across 2 columns

[Mike1256]

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

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[TMS]

See this thread for an idea how to approach this: https://www.excelforum.com/excel-for...paragraph.html

Note that if column I is where you input your data, it cannot have a formula in it.

[HansDouwe]

Here is a formula that returns everthing in one go.

Please put your words in A1 and try in A3:

Please Login or Register  to view this content.