I have a list of email address in column D3 through to D56 and want to put them all into 1 cell separated by “;”

Can someone point me in the direction of the correct formula please?

Use formula =D3&”,”&D4&”,”&D5 … Etc etc

Will then sonsolidate all cells into one with a comma seperating them.

Or, paste them into a separate workbook at A1, save that as a CSV, close it, open it in textpad, then find and replace “,” with “;”. Then paste the whole lot back into the origina.

in e3 to e56 type “;” (obv type it once, and copy & paste)

in a cell type formula: =CONCATENATE(D3:E56)

simples

In E3 use the formula =D3&”;”
In E4 use the formula =E3&D4&”;”
drag that all the way down to your last entry. The last one is what you want.