10 Replies Latest reply on Apr 26, 2018 10:10 AM by Deepak Rai

    Trim String Calculation


      I saw a post similar to what im trying to do but the wrong way around, please advise how I can do the below:


      Dimension value is in a string like below:

      "Bart Simpson - XXXXXX"

      "Maggie Simpson - XXX"


      I want a formula that will take the values from the right up to the space e.g XXXXXX and XXX


      Thanks in advance!