I am not an excel expert at all.. but I have to succeed in the next task:

I have received an excel file with only text in column A. This means that I have lines of sometimes 100 characters in one cell.

For printing labels on monday, I need to split up this one cell (or this one column) into cells containing maximum 20 characters and always ending with a blank/space or full word (so not cutting words in halfs). Question is: how do I automatically split a cell near the 20th character, pushing the remainder of the text to a next cell/column with again max 20 characters and so on?

I tried with this formula... but really some problems left and I loose all 'remaining text': =LEFT((MID(A1;1;20));LEN((MID(A1;1;20)))-LEN((RIGHT(MID(A1;1;20);FIND(" ";A1)))))

It seemed logical to first tell excel to find me the first 20 characters and then substract everything from the last blank onwards.. but this formula does'nt seem to cover that one ;o)

I hope someone can help here.

Thank you very much for your time and help!

All the best from Belgium (sleepy Belgium...)