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.

How to watch Rugby World Cup 2015 online: Watch live, catch up on-demand & stream the 2015 Rugby…

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

See immersive artist and storyteller Chris Milk speak at London VR event

What everyone thinks of the new Steve Jobs movie | 21 Facts about the Steve Jobs film | PLUS:…