How to make a line wrap formula in EXCEL after the third word?

Question

excel

Hello. Help with EXCEL formula
There is a column with a list of phrases. Phrases of different lengths, from 30 to 100 characters. Actually, I can't think of a formula that would insert a line break character (ALT + ENTER) after the third word if the line length is more than 50 characters.

Answer 1

=IF(LENG(A1)>50; REPLACE(A1;FIND(" ";A1;FIND(" ";A1;FIND(" ";A1)+1)+1);1;CHAR(10)); A1)
ps in the cell there should be a daw "wrap by words"

Answer 2

Look towards macros in VBA