textjoin help

[Dan88]

hello, i have a working formula but would like to replace the qoutes "" with '.

i cant seem to get it to work if someone can please point me in right direction.

Currently it joins a list of IDs and delimits with comma and open and end quotation marks. I would like to replace the open and closed qoutation marks with '

thanks in advance

=IF(TEXTJOIN(""",""",TRUE,H10:H47)<>"",CHAR(34)&(TEXTJOIN(""",""",TRUE,H10:H47)&CHAR(34)),"")

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Dan88]

hi Fluff, updated. I am on excel 365.

 

[Fluff]

Thanks for that
How about

=LET(a,TEXTJOIN("','",TRUE,H10:H47),IF(a="","","'"&a&"'"))

 

[Dan88]

Fluff, that worked. no way i wouldve figured that out.

As usual, thank you and thanks to those that contribute to this board. very much appreciated.

Thanks very much

 

[Fluff]

You're welcome & thanks for the feedback.