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 réponses

Réponse 1 / 2
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 
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
Yoakim
 
Great! Thank you so much :) :) :)
1