Copy and Paste Data from Induction Lab

Copy and Paste Data from Induction Lab

Select all rows and columns. Either highlight with your mouse or click on a cell and use the keyboard shortcut Ctrl+A or Cmd+A Copy the data (Ctrl+C or Cmd+C) Open up a blank sheet in Excel and make sure the A1 cell is highlighted.

In Home -> Clipboard (far left of the ribbon), click the dropdown arrow under the Paste icon. Click Paste Special (or Ctrl+Alt+V; Cmd+Alt+V) In the Dialog Box (Paste Special) select either "Unicode Text" or "Text", not "HTML" and click OK

Your data should fill in column and row separated

Save and Import data file

Select all rows and columns. Either highlight with your mouse or click on a cell and use the keyboard shortcut Ctrl+A Copy the data (Ctrl+C) Open up your computer's text editor (Notepad for Windows; TextEdit for Mac) to a new blank page Paste your data into your text editor (MAC USERS) If using TextEditor, select Format -> Make Plain Text before proceeding

Using the Save As... function (Ctrl+Shift+S or Cmd+Shift+S) save your data as a .txt file. Make sure it has the format `DataName.txt'

Open up Excel to a blank sheet page and make sure the first cell is highlighted

In the Data -> Get & Transform Data (far left) select From Text/CSV

Find your data file on your computer and load it into Excel. There may be a dialog box to preview it. Look it over and make sure each data point has its own cell. Then click Ok Excel should fill your in your data by row and column

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download