Saving Excel column as text

  belayer 16:38 23 Nov 10
Locked

I have done this before but cannot remember how!

I have a column of email addresses in an Excel document which I need to export into Word as a list seperated by a comma and space to form an email group, or to cut/paste into an email.

How did I do it?

  VoG II 16:50 23 Nov 10

I don't know how you did it before but try this. Press ALT + F11 to open the Visual Basic Editor, select Module from the Insert menu then paste into the white space on the right



Function ConCat(r As Range) As String
ConCat = Join(Application.Transpose(r), ", ")
End Function



Press ALT + Q to close the code window then in a spare cell enter a formula like

=concat(A1:A100)

to concatenate the values in A1 to A100. Then copy that cell and paste into Word.

  belayer 17:07 23 Nov 10

Wow, that is complicated. The Excel Help wizard tells me I can export the data straight into Outlook by using the Export command.

Only problem is that Excel doesn't seem to have an 'Export' command.

  VoG II 17:11 23 Nov 10

Ah, you didn't mention Outlook before. See click here

  belayer 17:26 23 Nov 10

That is brilliant, thanks!

  bremner 17:31 23 Nov 10

Highlight the column containing the email addresses in Excel.

Open Word and paste the data. Highlight it then go:

Table > Covert > Table to Text and choose your deliminator

  belayer 18:50 23 Nov 10

Thanks bremner, that is how I did it last time, thanks for the memory jog.

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

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

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

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…