Extract a column of data from Excel

  belayer 20:35 27 Jun 2009
Locked

Can anybody tell me an easy way to extract a list of names in a column in Excel and put them into a Word format or plain text??

  mgmcc 20:43 27 Jun 2009

If you highlight all of the names in the column, "copy" them, open a new Text Document (Notepad file) and "paste", that should give you the list in plain text format.

  belayer 20:48 27 Jun 2009

Thanks, that's great, I never thought of using notepad. I tried that direct into word but it pasted the grid lines with it.

Now I can just move it across from Notepad to Word.

Cheers!

  reddwarfcrew 18:12 28 Jun 2009

or paste into word and use the 'convert table to text' function.

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

Elsewhere on IDG sites

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?