Search and Replace a specific character

Hello,

In a cell(s) I have for example {text}dd%2BMore_Text}

what i want to do is search and replace the final }

so it should be {text}dd%2BMore_Text


the regular search and replace in excel removes all } which is not what i need.

Thanks

Say that its in A1 in cell B1 try typing

=LEFT(A1,LEN(A1)-1)

Not sure if it will work so make sure you save before trying

if this works then simply delete row a1 after

thanks guys, i figured it out.. IF(RIGHT(A1,1)="}",LEFT(A1,LEN(A1)-1),A1)