Pasted text is broken up
 

I pasted some text into a worksheet and it pasted it almost the way I wanted
it. I was like this...

|Text with spaces|
| |LXX=1234|LXY=12354|
|More text with spaces|

I used the "text to columns" and delimited to get this...

|Text with spaces|
| |LXX|=|1234|LXY|=|12345|
|More text with spaces|

That was exactly what I wanted so I went to the next worksheet and pasted
more info (same stuff with different numbers). This time it pasted like
this...

|Text|with|spaces|
|LXX|=|4576LXY|=|5698|
|More|text|with|spaces|

How do i get it to paste like it did the first time? Is there a way to do
the opposite of text to columns, with spaces seperating the words (without
using a formula)?

Please note that I am using '|' to show cell borders.

Excel remembers the settings when you do data|text to columns (it's just trying
to help!).

You have a couple of choices:

#1. Close excel and reopen it (yechhhh!)
#2. Do another data|text to columns, choose delimited, but remove all the
checkmarks for each delimiter.


I think your options are either using a formula:
=a1&" "&b1&" "&C1
or using a macro that accomplishes the same thing.

(There's no menu like data|columns to text in excel.)



Sloth wrote:

I pasted some text into a worksheet and it pasted it almost the way I wanted
it. I was like this...

|Text with spaces|
| |LXX=1234|LXY=12354|
|More text with spaces|

I used the "text to columns" and delimited to get this...

|Text with spaces|
| |LXX|=|1234|LXY|=|12345|
|More text with spaces|

That was exactly what I wanted so I went to the next worksheet and pasted
more info (same stuff with different numbers). This time it pasted like
this...

|Text|with|spaces|
|LXX|=|4576LXY|=|5698|
|More|text|with|spaces|

How do i get it to paste like it did the first time? Is there a way to do
the opposite of text to columns, with spaces seperating the words (without
using a formula)?

Please note that I am using '|' to show cell borders.

--

Dave Peterson