Formala or custom formatting to insert doube quotation

[Howardc1001]

I have used textjoin to combine text in one cell seperated by a comma


I would like to know how to insert a quote at the start of each text item and before each comma and after the last text item

I have used textjoin in C2 and have manually inserted double quotation marks manually in C3 to show you what I am trying to achieve -However if I have 20 + sheets, it is time consuming to do this manually



Your assistance is most appreciated

[Bo_Ry]

Please try

=TEXTJOIN(",",,""""&B2:B4&"""")

[Howardc1001]

Thanks for the help, but it only puts double quotation marks for items in B4

The desired results are in C3. Please amend formula accordingly

[Bo_Ry]

Pleasde try

=""""&TEXTJOIN(""",""",,B2:B8)&""""

[Howardc1001]

Thanks for the help. Formula works perfectly now


What does the , after the ) represent (have put it in red ) ?

Also what is the significance of index in this formula ?

Please Login or Register  to view this content.

[Bo_Ry]

I recommend to use
=""""&TEXTJOIN(""",""",,B2:B8)&""""

the =TEXTJOIN(",",,REPT(""""&B2:B8&"""",B2:B8<>""))
The red part is array formula you need to Press Ctrl+Shift+Enter

=TEXTJOIN(",",,INDEX(REPT(""""&B2:B8&"""",B2:B8<>""),))
The ,) if for INDEX that require 2nd argument.
Index can handle array formula, that help to use Normal Enter.

[Howardc1001]

Thanks for the explanation