To ask for help with a bloody sheets formula?

[Nancylovesthecock]

I want to join a string of text concurrently with each piece of text preceded and ended by an apostrophe and comma. Like this

'madeuptext','moremadeuptext',

So far i've managed the commas with =JOIN(",", B2:B523) but I can't work out how to get the apostrophes in. Help 😭

Go to cell C3
Enter =concatenate(B2,",",B3)
Then cell C4
Enter =concatenate(C3,",",B4)
Then drag the formula from cell C4 down to the bottom cell adjacent to the last (C523)
That should work :)

If "," is the delimiter you are currently supplying then would " ' , ' " not work? (Ive included spacing just to make it easier to read) im not sure because I havent used this exact function before

The bottom cell will contain the string containing all the text

I'm no expert and always look on You Tube for a tutorial to help me. - any use?

I love a concatenation 🥰

Not the neatest but make a new column for C2=“apostrophe”&B2&”apostrophe” and then use your formula on the C column instead? Where it says apostrophe put an actual apostrophe!

I don't know sheets syntax, but I'd expect you to need to nest your functions, something like:
=Concatenate(" ' ",join(" ',' ",b2:b523)," ' ")

Note that I've put extra spaces in to show the difference between apostrophes and quotes!

@Toomanyradishes

If "," is the delimiter you are currently supplying then would " ' , ' " not work? (Ive included spacing just to make it easier to read) im not sure because I havent used this exact function before

@Toomanyradishes

I could KISS YOU!

Thanks too @90skid

I honestly thought my brain would melt for a bit there.

Mumsnet to the rescue 😁

I came here to suggest soaking them in Oxyclean before washing, but now realise that won’t help in this situation!

I thought it was a laundry problem too!

@Nancylovesthecock im so glad that worked!

No problem! Happy to be able to offer some advice for a change, rather than harassing my colleagues for formulae

It's just not friendly to need to complete urgent data analysis on a Friday afternoon 😁