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
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