Separating a List Using Semi Colons

Copper Contributor

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 Replies


With M365...

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


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.


I know I don't know anything (Socrates)