Hi Seacue,
As an alternative 'in excel' approach to solving the data field with spaces import, this is a technique I have used:
EG:
Cell B2 has: The
Cell C2 has: cat
Cell D2 has: sat
Cell E2 has: on
Cell F2 has: the
Cell G2 has: mat
Insert a column before column B (All the other refs will move one letter to the right) then in the new cell B2 enter the following concatenation formula:
=C2&" "&D2&" "&E2&" "&F2&" "&G2&" "&H2
Copy that down for as many rows of data as you have:
B2 will now read 'The cat sat on the mat', but will be a formula. So select the whole column B, then copy (Ctrl-c) and Paste, Special, Values (Alt-e, s, v).
You can then delete columns C-H.
HTH
EG