how to extract caracters up to comma in excel cell
 

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

how to extract caracters up to comma in excel cell
 

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

how to extract caracters up to comma in excel cell
 

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


"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