CODEWITHSUNDEEP
excelexcel-formula
Sam
Sam

Reputation: 736

How to create a list of values from cell, separated by certain characters

I have a list that looks something like this

enter image description here

What I want to do is create a formula so in another cell I get the following

'ID1','ID2',ID3','ID4'

It doesn't matter if at the very beginning and at the very end I get extra characters because I can remove those manually, my issue is that in reality this list has hundred of IDs and I can't do this manually.

Upvotes: 0

Views: 526

Answers (1)

zsalya
zsalya

Reputation: 454

In next column (assuming data starting in A1):
in B1 = " ' " & A1 & " ' " and drag down (I added spaces to make readable, but you don't want them within the quotes in your actual formuale)
Then in C1 = B1, and in C2 = C1&","&B2, and drag down.

Upvotes: 1

Related Questions