split text in cell into 2 lines

G

Guest

I am needing help with formula. I have a cell that takes values from several
other cells to create one long line text (for a command used in other app).
For ex:
a1=jack
b1=ran
c1="There was a person named"&a1&"who was hungry and"&b1&" to Mcdonalds."
This process works great except when the line is greater than 72.
I need an if statment that says if c1 length is greater than 72 then to
split / replace line AFTER name(a1). Where the split occurs a +, and carriage
return needs to be added. So in the example above (pretend length will be
over 72, the output would be:
There was a person named Jack +
who was hungry and ran to Mcdonalds.

And of course if C1 length isnt greater than 72 - leave as is.

Any help with this would be greatly appreciated. I have lost enough hair -
from pulling it out, trying to figure this out.
Thanks again,
Jack
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top