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.