I have a column full of email addresses. I want to concatenate them with semicolons between them so that I can copy them all into my email and send them all bcc. Is there a way to do this without having to treat each one individually?
Md Ariful Islam
বিএসসি(সিএসই)
,
এমবিএ(মার্কেটিং)
8 views
1 Answers
Dr. Md Rushad Rahman
এমবিবিএস(আরপিএমসি)
,
পিজিটি(মেডিসিন)
Assume all your addresses are in column A. In B2, add the first two (=(A1&";"&A2). Then in B3, add A3 to B2 and then fill that formula down to the bottom of the list and you will have a cell with all that data.
8 views
Answered