how to extract caracters up to comma in excel cell

[jethan]

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

 

[Ken Johnson]

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 commaas
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

 

[Teethless mama]

=REPLACE(A1,FIND(",",A1),99,"")