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.

use FIND/REPLACE.
Find Function and Replace with
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


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

Hi gary, Mr. Rasoul has a tricky question....watch out for the advice if
there is a word "function" in the beginning or mid of the text in any
colum----result may be devastating for him? maybe u can suggest some basic
formula.

"Gary L Brown" wrote:

use FIND/REPLACE.
Find Function and Replace with
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


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

good point
- use a helper column
=trimleft(A1,right(A1,len(A1)-8))
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"romelsb" wrote:

Hi gary, Mr. Rasoul has a tricky question....watch out for the advice if
there is a word "function" in the beginning or mid of the text in any
colum----result may be devastating for him? maybe u can suggest some basic
formula.

"Gary L Brown" wrote:

use FIND/REPLACE.
Find Function and Replace with
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


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

Slight correction, Gary:

=trim(left(A1,right(A1,len(A1)-8)))

Hope this helps.

Pete

Gary L Brown wrote:
good point
- use a helper column
=trimleft(A1,right(A1,len(A1)-8))
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"romelsb" wrote:

Hi gary, Mr. Rasoul has a tricky question....watch out for the advice if
there is a word "function" in the beginning or mid of the text in any
colum----result may be devastating for him? maybe u can suggest some basic
formula.

"Gary L Brown" wrote:

use FIND/REPLACE.
Find Function and Replace with
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


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

I'm not convinced that it does help, Pete, or Gary.

In your formula
right(A1,len(A1)-8))
will remove the first 8 letters from the text string, and give you the
remaining right-hand end of the string.

You are then using that string as the second argument for the left function,
which not surprisingly returns a #value error.

Perhaps you intended to suggest
=TRIM(LEFT(A1,LEN(A1)-8))
--
David Biddulph

"Pete_UK" wrote in message
ups.com...
Slight correction, Gary:

=trim(left(A1,right(A1,len(A1)-8)))

Hope this helps.

Pete

Gary L Brown wrote:
good point
- use a helper column
=trimleft(A1,right(A1,len(A1)-8))
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was
this
Post Helpfull to you?''.


"romelsb" wrote:

Hi gary, Mr. Rasoul has a tricky question....watch out for the advice
if
there is a word "function" in the beginning or mid of the text in any
colum----result may be devastating for him? maybe u can suggest some
basic
formula.

"Gary L Brown" wrote:

use FIND/REPLACE.
Find Function and Replace with
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to
''Was this
Post Helpfull to you?''.


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

Yes, you're right David -I just spotted trimleft in Gary's posting and
thought that isn't a function!

Pete

David Biddulph wrote:
I'm not convinced that it does help, Pete, or Gary.

In your formula
right(A1,len(A1)-8))
will remove the first 8 letters from the text string, and give you the
remaining right-hand end of the string.

You are then using that string as the second argument for the left function,
which not surprisingly returns a #value error.

Perhaps you intended to suggest
=TRIM(LEFT(A1,LEN(A1)-8))
--
David Biddulph

"Pete_UK" wrote in message
ups.com...
Slight correction, Gary:

=trim(left(A1,right(A1,len(A1)-8)))

Hope this helps.

Pete

Gary L Brown wrote:
good point
- use a helper column
=trimleft(A1,right(A1,len(A1)-8))
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was
this
Post Helpfull to you?''.


"romelsb" wrote:

Hi gary, Mr. Rasoul has a tricky question....watch out for the advice
if
there is a word "function" in the beginning or mid of the text in any
colum----result may be devastating for him? maybe u can suggest some
basic
formula.

"Gary L Brown" wrote:

use FIND/REPLACE.
Find Function and Replace with
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to
''Was this
Post Helpfull to you?''.


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

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

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.

Hi again Rasoul....pls check up the best reply for you..so we all learn over
this thread....tks all..

"Ron Coderre" wrote:

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.

Thanks for replies.

"Pete_UK" wrote in message
oups.com...
Yes, you're right David -I just spotted trimleft in Gary's posting and
thought that isn't a function!

Pete

David Biddulph wrote:
I'm not convinced that it does help, Pete, or Gary.

In your formula
right(A1,len(A1)-8))
will remove the first 8 letters from the text string, and give you the
remaining right-hand end of the string.

You are then using that string as the second argument for the left
function,
which not surprisingly returns a #value error.

Perhaps you intended to suggest
=TRIM(LEFT(A1,LEN(A1)-8))
--
David Biddulph

"Pete_UK" wrote in message
ups.com...
Slight correction, Gary:

=trim(left(A1,right(A1,len(A1)-8)))

Hope this helps.

Pete

Gary L Brown wrote:
good point
- use a helper column
=trimleft(A1,right(A1,len(A1)-8))
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to
''Was
this
Post Helpfull to you?''.


"romelsb" wrote:

Hi gary, Mr. Rasoul has a tricky question....watch out for the
advice
if
there is a word "function" in the beginning or mid of the text in
any
colum----result may be devastating for him? maybe u can suggest some
basic
formula.

"Gary L Brown" wrote:

use FIND/REPLACE.
Find Function and Replace with
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to
''Was this
Post Helpfull to you?''.


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