concatenation issue with over 1800 IDs

[gmccray]

I need a quick way to concatenate over 1800 IDs like cell A1:mccrayg, A2:gmcay, A3:marshal6 ..... to se this u properly to be used in a sql query it would take forever using =Concatenate("'",A1,"'",",","'"A2, .....etc

can anyone assist me?

 

[Fluff]

Do you want to concatenate all values in col A?
Also do you have Office 365?

 

[gmccray]

Do you want to concatenate all values in col A?
Also do you have Office 365?

Yes to both!

 

[Fluff]

The have a look at TextJoin, otherwise you'll need a macro.
https://exceljet.net/excel-functions/excel-textjoin-function

 

[GR00007]

You might make it with this:

="A"&ROW(A1)&":"&A1
=B1&", "&"A"&ROW(A2)&":"&A2

Put the first one in B1, the second in b2, then copy B2 down.
This will concatenate iteratively and you just select the last cell for the full concatenation.
BE CAREFUL: the limit for a cell length is 32K+ bytes, I tried it with values averaging 11 bytes in column A and it got to over 1800 rows before it hit the limit.