Opposite of Text to Columns

[rhaney]

Good morning.

When I get certain emails, if I copy and try to paste it into a cell, it turns out that each word would be placed into its own cell across multiple columns.

How could I take this sentence with varied length and put the info into a single cell with a space between the words?

Thank you for your assistance!

Robert

 

[VoG]

If this behavior occurs after using Text to Columns, click in any cell containing data, Text to Columns, check Delimited, click Next, uncheck everything then click Cancel.

Then try pasting in the e-mail text.

 

[rhaney]

Thank you!

Robert