excel help on concatenate formula

  robert01 13:34 PM 02 Jul 13

I have a list of email addresses in cells A1, A2 etc up to about 100, I need to put them in one long string ready to paste into a word document seperated by ; and a space.

How can I do this rather easily than manually type out a formula ?

  bumpkin 15:00 PM 02 Jul 13

Hide the grid, copy and paste into Word possibly but you may have to add the colons.

  Woolwell 15:20 PM 02 Jul 13

You do not need to hide the grid to do what bumpkin suggests but this does not add semi-colons or colons.

Which version of Excel and Word?

I guess that you will copy and pasting the list into the address line of an email. Which email client will you be using? It may better to create a distribution list.

  Woolwell 15:25 PM 02 Jul 13

I have just had a play and if you copy and paste as suggested then in Word use find and replace, replacing the paragraph mark with ;space then it works.

  bumpkin 18:08 PM 02 Jul 13

Woolwell, I like that, nice easy solution.

  robert01 13:38 PM 13 Aug 13

worked, thanks


This thread is now locked and can not be replied to.

Best Cyber Monday deals 2015 live blog: Best UK Black Friday weekend deals & best UK Cyber Monday…

1995-2015: How technology has changed the world in 20 years

The best Black Friday Deals for designers and artists – updated

20 Mac Power User Tricks... That You Didn't Know