Text

[cornishteeth]

What formula would I use to compile text in 100 cells. For example, I have email accounts in cells A1 to A5 followed by a semicolon. What formula would I use to bunch everything together so I can send it to Outlook and out to all the addresses?

 

[Lewiy]

=CONCATENATE(A1,A2,A3,A4,A5)