Worksheet Question

[CAHooker300]

i'm trying to create a new worksheet from a table that was sent to me in an email ... is there an easier way to do that besides just re-typing all of the number?

[Fettertiger]

Hi,

did you try "Copy&paste" into a new worksheet? If that does not work usually Copy & PasteSpecial as Text should help.

Regards
Theo

[CAHooker300]

where do i find "copy&paste" on the toolbar? what do you mean by "pastespecial"?

or do i need to go to another forum?

[ChemistB]

1.Select the data in the table in your email.
2. CNTRL + C to copy or right click and "Copy"
3. Go to Excel, select the same number of cells as in your original data (i.e. 3 x 12)
4. Paste

If that doesn't work
Step 3. Select a single cell
4. Right click > Paste Special > text
5. Go to the data tab in excel > "Text to Columns"
6. Run through the window to separate your values by Tabs or spaces or whatever work (Experiment)
Hope that helps.

[shg]

ChristyT71 is banned permanently.

CAHooker300 is banned for two weeks.