Can I?

O

oldtrout

Using Excel 2000

I have two columns. I want to remove the info from each column so that the info is in a list and not in cells.

Can it be done and how?

Thanks

oldtrout
 
L

LoriM

Here's what I would do...

Copy & paste the cells in Word. That will put the info in a Word table. If
you don't want a table, you can then do "Table | Convert | Table to Text" to
get a list.

If you need it back in Excel, just copy the text and paste back into an
Excel cell.

Hope this help.
 
L

LoriM

Clairification: If you want all of the info in one Excel cell, Edit the cell
and then paste the info. HTH
 
G

Gord Dibben

trout

No too clear what you want done.

Can you give a sample of your data and what results you wish?

Don't attach a file, just a sample description.


Gord Dibben Excel MVP
 
O

oldtrout

Here's what I would do...
Copy & paste the cells in Word. That will put the info in a Word table.
Click to expand...

I should have been clearer in my request.

That is where I had put it.
If you don't want a table, you can then do "Table | Convert | Table to Text" to
get a list.
Click to expand...
If you need it back in Excel, just copy the text and paste back into an
Excel cell.
Click to expand...

Nope I wanted it in Word without the table, just like it now is, thanks to your help. :)

Many thanks

oldtrout
 
J

JulieD

Hi

just to clarify ..

you have information in two columns in excel, ie the range A1:B10

you want to copy the information into word, so that it comes into two
columns A1:A10 on the left & B1:B10 on the right, BUT you don't want it in a
table in Word.

My first question would be why don't you want it in a table in Word - as you
can hide the table boundaries so when it prints or whatever it doesn't look
like it's in a table.

However, if i'm on track with what you want and you really don't want to use
a table in Word, this is how i would do it.
(i would do it to a blank document first and then incorporate it in another
document if needed)
1) copy the first range A1:A10
2) switch to Word, paste the range - when the smart tag comes up (the
flashing clipboard thing- in ver 2000 and above) choose "keep text only".
If you don't have this option, once it's pasted, click inside it and choose
table / select table then table / convert / table to text - ensure paragraph
marks are checked and click Ok
3) click on the line under the last pasted entry (you might have to press
ENTER to get there) choose insert / break / column (don't worry about how
word reacts to this - we'll fix it later)
4) copy the second range B1:B10
5) switch to Word and repeat step 2 pasting the information below the other
information (and the column break line - if you can't see this line, click
on the backwards P next to the zoom icon on the top toolbar to display the
paragraph markers) .. ensure that this is also converted to text and is not
a table.
6) click anywhere within your data and choose format / columns - choose 2
and i think you should have the result you're looking for.

Hope this helps
Cheers
JulieD
 
Top