On Jul 24, 10:13 pm, jethan wrote:
I have a cell in excel with a text example :
Bibliothèque Serena, 2 tiroirs, Teck, 85x33x190 cm

how to extratc automatcially in excel :
Bibliothèque Serena

and put it in another cell.

I see how to do it with a fix number of caracters but not up to the comma as
the number of caracters is variable

Thank you

If Bibliothèque Serena, 2 tiroirs, Teck, 85x33x190 cm is in A1 then
one way is...

=LEFT(A1,FIND(",",A1)-1)

Ken Johnson