add a semi colon after each email address

Hi,

I just need to know a formula or a way to add a semicolon after each email address, so I may export it properly to my email account.

Thanks,
Elana

If your email addresses are in column A, starting with A2, then you can put this formula in B2:

=A2&"; "

If you have a different layout then you will need to describe it, as I don't think anyone on this forum can read minds.

Hope this helps.

Pete