How to remove text before the dash (-) sign

Ana22
edited December 2022 in Modeling

Hi, 

 

I have a line item where I need to remove all those before the dash (-). Is  there a way to do this?

 

currentexpected
XXX - 123123
XX - 12341234

 

Thanks!

Tagged:

Best Answer

  • KirillKuznetsov
    edited December 2022 Answer ✓

    @Ana22 

    MID() and FIND() formulas will help here:

    expected = MID(current,FIND("-", current)+1,<n>)

     

    where <n> - max number of characters thich may appear after the dash sign.

Comments

  • Ana22
    edited December 2022
    Thanks!! It worked! 🙂
  • jakesachs
    edited December 2022

    Hi! Could you help me essentially find the reverse of this? Basically I want to find everything to the Left of the dash.