Add characters to a cell Excell 1

[Cpreston]

Hi

I have a cell of Text which I want to add some characters to and then join them all together in one string separated by a comma.

I have managed to join all 455 rows with a comma using this formula =TEXTJOIN(",",TRUE,A1:A455)

A-GRN-R2-ARM1,A-GRN-R2-ARM2, etc......

However I want to produce the below with the ' at the start and end of each cell and then the comma

'A-GRN-R2-ARM1','A-GRN-R2-ARM2', etc....

I have played with the formula but can not get it to produce it correctly

Any ideas pleas.

Thanks in advance

 

[combo]

You can add "'" before and after the formula:
[tt]="'"&TEXTJOIN(",",TRUE,A1:A455)&"'"[/tt]

combo

 

[Cpreston]

Hi Combo

I tried your formula and I get this

'A-GRN-R2-ARM1,A-GRN-R2-ARM2' etc

What I am trying to acheive is

'A-GRN-R2-ARM1',A-GRN-R2-ARM2','next code','next code' etc....

Many thanks

 

[combo]

If you replace "," by "','" in TRXTJOIN separator you should get what you expect.

combo

 

[Cpreston]

Thanks that worked perfect, many thanks