View original (French)

Remove characters after defined character

Solved
Yoakim -  
 Yoakim -
Hello,

I am desperately looking for a formula or VB code that allows me to remove the characters from a cell after the first defined character encountered, in this case ","

Example of desired conversion:

"Darcheux,Roger,Mme et M." = "Darcheux"

Thank you for your help :)

Configuration: Windows XP / Internet Explorer 8.0

2 answers

  1.
    PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    the text is in A5 here is the formula

    =LEFT(A5;SEARCH(",";A5)-1)

    --
    Practice makes perfect. - It's when you're up against the wall that you see the mason - you always learn from your mistakes
    13
    1. Yoakim
       
      Great! Thank you so much :) :) :)
      1