is there a simple way to do this?

  • Thread starter Thread starter Laurence Smith
  • Start date Start date
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
 
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.
 
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.
Click to expand...

Thank you.
That worked for me.
 
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
Click to expand...

free ASAP Utilities has this function
 
Back
Top