How to remove duplicates from one single cell

[FlashDota]

Hello,
Is there a formula for removing duplicates in just one cell from the following text. Formula would be better, but VBA would be fine too

Cell A1: Stem account international: Institution per Biznes, Head Accounting & Audit L.L.C. Head Accounting & Audit L.L.C.;1001001001001000;Institution per Biznes;FILAN FISTEKU BI;LETRA 15-TFV11-123-145;LETRA 15-TFV11-123-145

 

[DanteAmor]

Try in cell B1

=TEXTJOIN(";",,UNIQUE(TEXTSPLIT(A1,,";")))

 

[FlashDota]

Try in cell B1

=TEXTJOIN(";",,UNIQUE(TEXTSPLIT(A1,,";")))

Not working

 

[KevCarter]

Mr. DanteAmor's formula worked for me. It removed one instance of "LETRA 15-TFV11-123-145"

Perhaps you have different expectations of what should be removed?

 

[DanteAmor]

Not working

What does the formula return?
Do you have these textjoin, textsplit, unique functions in your 365 version?

And what is the result you want?

 

[FlashDota]

What does the formula return?
Do you have these textjoin, textsplit, unique functions in your 365 version?

And what is the result you want?

Hi Dante, thanks for the reply. I actually have office 2021 (my bad, fixed it on my account settings also). I want to remove the Head Accounting & Audit LLC as well as LETRA 15... so every text that is duplicate