Try

=SUBSTITUTE(A1," "," %",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))


--

Regards,

Peo Sjoblom

"George" wrote in message
...
That is very helpful but I should have been more clear.
What I really need to do is add a character (ie. %) to the begining of the
last word.

Thanks for your help.

"Vito" wrote:


Assuming spaces between words, try

=SUBSTITUTE(A1,(RIGHT(A1,LEN(A1)-FIND("@",SUBSTITUTE(A1,"
","@",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))),B1)

Where A1 contains the phrase and B1 contains the new word to insert.

You can also replace teh B1 in the formula with the actual word in
double quotes, if desired.


--
Vito
------------------------------------------------------------------------
Vito's Profile:
http://www.excelforum.com/member.php...o&userid=29182
View this thread:
http://www.excelforum.com/showthread...hreadid=493901