how to extract caracters up to comma in excel cell

J

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
 
K

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
Click to expand...

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

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

Ken Johnson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference to a Variable Part of a Cell 7
How to sort column... 2
How to extract separated text by many commas in Excel? 0
HOW TO COUNT characters in field 2
removing comma 4
Counting the number of times a character occurs in a cell 1
How specify number format of cell value in concatenate function? 1
How to add an inverted comma in a cell? 2

Top