MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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.