Saving Excel column as text

  belayer 16:38 23 Nov 2010
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 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

=concat(A1:A100)

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

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?