Strip Character from Right

[Guest]

Is there a way that I can take a cell and strip 1 character from the right side. I have several hundred email addresses that are in the format

(e-mail address removed)

(e-mail address removed)

I need to take the ")" off the string...and it is always the last item in the cel

Thank

 

[Alan]

Two possible ways,
=LEFT(A1,LEN(A1)-1)
=SUBSTITUTE(A1,")","")
Regards,

Is there a way that I can take a cell and strip 1 character from the right

side. I have several hundred email addresses that are in the format:

 

[Debra Dalgleish]

Select the column of addresses.
Choose Edit>Replace
Find What: )
Replace with:
(leave the Replace with box empty)
Click Replace All