Split sentence into rows - No wrapping

[cshetty]

I have a tricky requirement. (Tricky for me )

My sentence in excel cell is "US DOLLARS NINE HUNDRED SIXTY EIGHT THOUSAND SEVEN HUNDRED FIFTY SEVEN ONLY"

I need to print this on a pre printed pay-order stationery. The width of the line is limited on the stationery. I can print up to US DOLLARS NINE HUNDRED SIXTY EIGHT THOUSAND SEVEN HUNDRED on the first line and FIFTY SEVEN ONLY should go to the next line on the stationery.

I tried with wrapping the text in excel cell, but one of sentence prints on the line of the stationery.
Is there a way to split the line using a formula so that i can distribute the line into two rows.

Hope i have explained my query properly.

 

[cshetty]

Why would you have to do that? My examples don't have a space at the end.

Sorry, my mistake. I just messed up things. Your Solution works as it is.
Thank you, sir.

 

[Peter_SSs]

You're welcome. Glad you got it sorted in the end.