If you only want to remove "function" from the end of a cell...

Try this:

With
A1: (any value or blank)
B1: =TRIM(IF(COUNTIF(A1,"*function"),LEFT(A1,LEN(A1)-8),A1))

Example:
Using A1: This function is my function
The formula returns: This function is my

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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.