Saving Excel column as text

  belayer 16:38 23 Nov 2010

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 2010

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


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

  belayer 17:07 23 Nov 2010

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 2010

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

  belayer 17:26 23 Nov 2010

That is brilliant, thanks!

  bremner 17:31 23 Nov 2010

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 2010

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.

Elsewhere on IDG sites

Huawei MateBook X Pro review: Hands-on

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?