Thread: delete a word from end of a text
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aladin Akyurek Aladin Akyurek is offline
external usenet poster
  
Posts: 52
Default delete a word from end of a text
=TRIM(IF(RIGHT(A2,8)="function",SUBSTITUTE(A2,RIGH T(A2,8),""),A2))

Rasoul Khoshravan wrote:
I have a column of texts. All of texts have the word "function" at end
of them.
I want to delete this word from end of all texts.
How can I do it.
Reply With QuoteReply With Quote