KNOWLEDGEBASE - ARTICLE #1503

Copy and paste tabular results from InStat to Excel. Aligned!

 InStat presents the results in text tables, using multiple spaces to align columns. It looks great within InStat, and prints fine. But if you copy the results and paste into Excel, it becomes a mess. The problem is that Excel only sees a paragraph, not a table, so it pastes everything into one column.

But it is easy to fix things so the results are tabular within Excel:

  1. Select and copy a block of tabular results from InStat.
  2. Go to an empty table in Excel. Put the insertion point in the top left cell and paste.
  3. Select the first column in Excel. This column contains everything you pasted.
  4. Drop the Data menu. In Excel 2007, go to the Data tab.
  5. Choose the Text to Columns command. In Excel 2007, click the button with that name.
  6. Choose Fixed Width.
  7. Finish the wizard, and your data will be in aligned Excel columns.

I've tested this with Excel 2007 (Win) and 2008 (Mac). It ought to work with earlier versions as well. I was not able to find a similar command in Numbers (part of iWork for Mac).

Explore the Knowledgebase

Analyze, graph and present your scientific work easily with GraphPad Prism. No coding required.