=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