Separating a List Using Semi Colons

[LL19911695]

I have a list of data (example in the screenshot below) which I want to put into one single cell, with each value separated by semi colon followed by a space, i.e: Abc.Def; Xyz.Mno; Pqrs.Tuv

Any ideas how I can do this?

[#2]

@LL19911695 

With M365...

=TextJoin("; ",1,C2:C4)

[#3]

@LL19911695 

In the attached file you will find an example of how to do this.

Additional information/links:

Split text into different columns with the Convert Text to Columns Wizard

Split text into different columns with functions

I would be happy to know if I could help.

NikolinoDE

I know I don't know anything (Socrates)