Importing text into Excel...
Greetings, I have some reports generated as .RTF files, I can open them and
save them as .txt files for import into Excel.
With the text import wizard you can create line breaks thus separating data
into columns. However since I have some large text descriptions in the file
I want to have numerous lines be imported into the same row. Presently it
sticks one line of text into each separate row. Is this possible or am I
missing something obvious?
Thanks for any help.
|