How to remove last character if a string if it is present from a Spreed Sheet/ Excel field July 04, 2013 Assume A1 is the field containing the string records and you want to remove pipe("|") symbol if it ends with pipeline. Just ...