Excel formula to remove remaining text after coma

[mysticmario]

Hi, see below screenshot. the formula i created produces the result shown above it.
I want to also add a formuala to remove text after the coma. it is the second coma in that full text.

I tried using double =find() function, but my brain melted after 40 minutes tryign to make it work, so as usual I seek help with you guys.
Thank you in advance.

 

[Fluff]

Do you have the Textsplit function yet?

 

[Joe4]

Try this:

=MID(C62,FIND(",",C62,FIND(",",C62)+1)+1,256)

 

[mysticmario]

Do you have the Textsplit function yet?

No i dont unfortunately

 

[mysticmario]

Try this:

=MID(C62,FIND(",",C62,FIND(",",C62)+1)+1,256)

results - this thign gives me a headache

 

[Joe4]

Sorry, I missed the fact that your version of Excel uses semi-colons instead of commas as argument separators.
So try:

=MID(C62;FIND(",";C62;FIND(",";C62)+1)+1;256)

 

[Fluff]

How about

=LET(r;REPLACE(C62;1;FIND(",";C62);"");TRIM(LEFT(r;FIND(",";r)-1)))

 

[mysticmario]

How about

=LET(r;REPLACE(C62;1;FIND(",";C62);"");TRIM(LEFT(r;FIND(",";r)-1)))

My brain melted even harder reading this but it works perfectly, thank you

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Joe4]

Sorry, I think I misunderstood the question (I probably should have asked for an example of the expected output).
Glad Fluff got it worked out for you.