using a formula inside a sting of text
 

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.

--
Thanks,
Laura

using a formula inside a sting of text
 

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 /


On Mar 12, 8:31 am, lauras03
wrote:
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.

--
Thanks,
Laura

using a formula inside a sting of text
 

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

--
Don Guillett
SalesAid Software

"lauras03" wrote in message
...
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.

--
Thanks,
Laura