arranging text
Posted by Joe on September 21, 2001 7:50 AM
How would I copy and paste this message (for example), to a spreadsheet and have it separate words or phrases in a pre-determined way? The program we use at work is not compatible with excel so I am trying to copy from the screen and paste to the spreadsheet so I can email to our clients. However, when I paste it the result is not organized in a presentable way. Please help!!!
Posted by Chris on September 21, 2001 9:46 AM
In a simple test document you can use the tab key to seperate fields for text. Also the Enter key would start a new row.
For example
1 2 3 4 5
Seperated by the tab key would put each number, or word or phrase into a different column. If you do not seperate using the tab key it will all be put in the same cell.
Using enter for each new row would put each new row in a new row in the spreadsheet.
