using a formula inside a sting of text

[Guest]

I have an invoice with some wording about canceling and want to include a
name (seller) and address (residence) in the middle. Is there an easier way
than the way I am doing it. I want to be able to change the name and address
when necessary.

What I have been doing is copying the text into several cells and deleteing
parts and putting it back together from different sentence fragments.

Example:
Compete string: If you cancel, you must make available to the seller at your
residence, ... risk.

=A30&A33&LEFT(F16,FIND(" ",F16)-1)&A31&D10&A32
This finds first name, how do I find last?

A30: If you cancel, you must make available to
A31: at
A32: , ... risk.
A33: Mrs.
D10: 123 Oak Street
F16: Laura Smith

Final reads: If you cancel, you must make available to Mrs. Smith at 123
Oak Street, ... risk.

 

[tylagusim]

That seems reasonable to me. The formula gets long (obvioulsy) but the
underlying approach is clear and straightforward.
You might consider making it more complicated, though, by separating
first and last names into separate cells.Your current formula assumes
a blank space delimits the first and last names. This isn't
particualrly true.

/ Tyla /

 

[Don Guillett]

=RIGHT(M15,LEN(M15)-FIND(" ",M15))