How to remove last character if a string if it is present from a Spreed Sheet/ Excel field

Assume A1 is the field containing the string records and you want to remove pipe("|") symbol if it ends with pipeline. Just use this formula to remove just last pipeline :-

 =IF(RIGHT(A1,1)="|",LEFT(A1, LEN(A1)-1),A1)

Note:- Helped by Sabrish (my colleague)