is there a simple way to do this?

L

Laurence Smith

Let's say you have 20 names in cells a1 to a20.

If you copy them and then paste them elsewhere in Excel, Wordpad,
Notepad etc. they show up like this.


item 1
item 2
item 3
etc. down to
item 20


Is there a way to do the paste so that they are all on the same line?:

item 1 item 2 item 3 item 4 etc to item 20?

TIA
 
I

isabelle

hi Tia,

you have to make a paste special "Unformatted Text"
then on Word's Edit menu, click Find or Replace.
If you don't see the Special button, click More.
click Special, and then click the item " paragraph mark "
enter what you want to use as a replacement in the Replace with box and then click Replace All.
 
L

Laurence Smith

isabelle said:
hi Tia,

you have to make a paste special "Unformatted Text"
then on Word's Edit menu, click Find or Replace.
If you don't see the Special button, click More.
click Special, and then click the item " paragraph mark "
enter what you want to use as a replacement in the Replace with box
and then click Replace All.

Thank you.
That worked for me.
 
Z

Zaidy036

Laurence Smith at [email protected] said:
Let's say you have 20 names in cells a1 to a20.

If you copy them and then paste them elsewhere in Excel, Wordpad,
Notepad etc. they show up like this.


item 1
item 2
item 3
etc. down to
item 20


Is there a way to do the paste so that they are all on the same line?:

item 1 item 2 item 3 item 4 etc to item 20?

TIA

free ASAP Utilities has this function
 
G

Gord Dibben

In Excel...................Copy>Paste Special>Transpose


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top