Extract data from a cell before a comma ...

Hello,
You can use LEFT with FIND

something like this:

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

--
Best regards,
Jordane

Thank you for your quick response. I tried your formula, but it doesn't work; I'm getting an error result.

I'm in cell D1 and I want the info from cell E1.
I modified it with these values, but nothing works...

Let me show you the line from which I want to retrieve the info: (CELL E1)
Acer TravelMate P645-S-59TX - Ultrabook - Core i5 5300U / 2.3 GHz - Win 7 Pro 64 bits / Win 10 Pro 64 bits - 4 Go RAM - 500 Go lecteur hybride - 14" 1366 x 768 (

And I need, therefore: (CELL D1)
Acer TravelMate P645-S-59TX - Ultrabook - Core i5 5300U

So before the / and depending on the cases of ,

Thank you again.

Hello,

well, my friend Vaucluse, whom I greet, responded with
=LEFT($D1;SEARCH("/";$D1;1)-1)
you also have
=LEFT($D1;FIND("/";$D1;1)-1)

now we need to be careful with the number of criteria in your input, especially if they come before the part to extract and if there are different criteria that are difficult to manage
Talk to you later
Mike-31

Not knowing is not a failure, failure is the refusal to learn.

Thank you again, I've tried everything but nothing works.

At worst, can you maybe try to give me the formula to stop just at the slash (i.e., to find all the values and transcribe them up to the slash)?

My apologies, you’re going to think I’m a NOOB

I admit my mistake:
But my case was E2 and not E1 .....

I really thank you, this will help me automate tedious tasks....
And I apologize again for my incompetence

I hope you won’t ignore me on my next Excel questions....

So, for the slash or the comma, this formula works perfectly:

=LEFT(E5;IF(ISERROR(FIND(",";E5));FIND("/";E5);FIND(",";E5))-1)

After applying it to my table, it seems that in some cells, it takes into account what is after the slash.....
Strange, but in any case, the first function works, so!!!

This one doesn’t work for me
=TRIM(LEFT(A1;IF(ISERROR(FIND(",";A1));FIND("/";A1);FIND(",";A1))-1))

Again, and to avoid creating another topic, I would need your help.

I need to be able to copy a cell and automatically add text to it in the formula.

I want to add .jpg to the text copied from another cell.

I start from cell B2 containing the reference: REOSDP4T4ERTEJ

To be transmitted in another cell using the function "="
Adding .jpg, of course.

So, I want to end up with:

REOSDP4T4ERTEJ.jpg

I found this formula while searching: =B2& ".jpg"

But I would like to add text before, for example: dossier\REOSDP4T4ERTEJ.jpg

How can I do that?

Well, I found it:

="dossier\" & B2 & ".jpg"

THANK YOU!!!!