How do I remove all text before/after a specific character without formula

How do you sign up for all of composing beforeafter any particular identity whilst not having collaboration