View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jethan jethan is offline
external usenet poster
 
Posts: 1
Default 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