| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I replace the last entire word in text cells?
That is perfect! Thank you very much.
"Peo Sjoblom" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| question about removing text from cells, leaving numbers | Excel Discussion (Misc queries) | |||
| Split Long Text Cell into Two Shorter Cells Without Splitting Word | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Threaded Mode
