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!