2 Replies Latest reply on Feb 2, 2012 1:25 AM by Xavier P

    Use of FIND for a character present several times

    Xavier P

      Hi peeps

       

      I have two columns of data e.g.

       

      Julius | Romans Inc - Julius Caesar - Feb. 32

       

      I would like to extract the first part of the second column only, i.e. Romans Inc.

       

      I did this calculation:

       

      LEFT([Column 2],LEN([Column 2])-FIND([Column 2],"-")) but this is returning "Romans Inc - Julius Caesar"

       

      How can I specify this is only for the first "-" ?

       

      Thanks in advance!