Strip Character from Right

W

WDP

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

[email protected]

[email protected]

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

Thank
 
A

Alan

Two possible ways,
=LEFT(A1,LEN(A1)-1)
=SUBSTITUTE(A1,")","")
Regards,
WDP said:
Is there a way that I can take a cell and strip 1 character from the right
Click to expand...
side. I have several hundred email addresses that are in the format:
 
D

Debra Dalgleish

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