I need to take content from an Excel spreadsheet (see below for example), that takes up about 20 cells, and paste it into one cell. I've tried pasting it into Word or notepad documents, and then pasting it back, but it still tries to import it back in tab delimited format (taking up the 20 cells again).
I need to turn this:
Title: Farmers Eating
Year: 1980
Categories: Bulls
Prairies
Shepherds
Farmers
Geographical Area: Midwest, South
Into this:
Title:Farmers Eating Year:1980 Categories:Bulls Prairies Shepherds Farmers Geographical Area:Midwest, South
So that it fits back into one cell.