| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract the text between last comma and last but one comma. | Excel Worksheet Functions | |||
| How can I extract the first & last name separated by a comma | Excel Discussion (Misc queries) | |||
| count the number of caracters in a cell | New Users to Excel | |||
| count the number of caracters in a cell | New Users to Excel | |||
| Extract comma broken address to cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
