I have a variable length space delimited long string in this format:

Word1 Word2 Word3 Word4 Word5....

My CR text field is N characters long
I wish to make a newline (don't want to use 'will grow') by replacing
a space character with a CHR(13), the closest space that's < N.

i.e.

Word1 Word 2 Word3
Word 4 Word 5

How can I find and replace that space character?

Thanks