Separating a List Using Semi Colons

Occasional 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?

 

LL19911695_0-1677232408567.png

 

2 Replies

@LL19911695 

With M365...

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

@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)