We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

excel help on concatenate formula


robert01

Likes # 0

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 ?

Like this post
bumpkin

Likes # 0

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

Like this post
Woolwell

Likes # 0

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.

Like this post
Woolwell

Likes # 0

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.

Like this post
bumpkin

Likes # 0

Woolwell, I like that, nice easy solution.

Like this post
robert01

Likes # 0

worked, thanks

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

45 Best Android games: top Android games for your smartphone or tablet in 2014 (24 are free!)

IDG UK Sites

How Apple, Adobe, Microsoft and others have let us down over UltraHD and hiDPI screens

IDG UK Sites

Do you have the X-Factor too? Mix Off app puts fans in the frame

IDG UK Sites

iPad Pro release date, rumours and leaked images - 12.9 screen 'coming in 2015'