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 ?
Hide the grid, copy and paste into Word possibly but you may have to add the colons.
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.
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.
Woolwell, I like that, nice easy solution.
This thread is now locked and can not be replied to.
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?
© Copyright 2017 IDG UK. All Rights Reserved.