String in Column A to be divided into 2 Strings if leght > 50

[mesje]

Hello All,

I have a set of data in Which in column A is the name of organisation.
If string in col A is longer than 50 I need to split in and put in col B.
That would be simple however I need to do it in a smart manner: i.e. cut it to the nearest full word.
Example:

THIS EXAMPLE NAME IS TOO LONG TO FIT INTO 50-TEXT CRITERIA SO I NEED TO DIVIDE IT INTO TWO STRINGS
Incorrect; lengt = 98

THIS EXAMPLE NAME IS TOO LONG TO FIT INTO 50-TEXT
Correct; trimmed down to 48.

My question is about formula that can detect spaces and depending on those trim the string down adequatly:
to 50 if 50th char is preceeded by space; if not then check where is the next space going towards left. Once you find it cut the string there.

Any ideas what formulae I can use to get desired effect?

Thank you,
Mesje

 

[mesje]

Thank you very much for all replies.
It took me a while to digest the answers but it was worthwile exercise!

Thanks to all contributors to that thread