Copy text from multiple cells

Question

Level 1

0 points

Copy text from multiple cells

How do I copy the text (cell contents, not cell) in multiple cells (all at once)?

I am trying to cut and paste the text from a Numbers table (actually an Excel file opened in Numbers) to a text box in InDesign to create an InDesign table.

When I select multiple cells and Command 'C', I copy the cells not the content.

It was easy in Excel... but I am trying to avoid installing 'Office' on my new MacPro!

Help much appreciated.

Mac Pro, OS X Mavericks (10.9.2)

Posted on Apr 9, 2014 12:10 AM

Reply

Answer 1

SGIII

Level 8

37,562 points

Apr 9, 2014 2:50 AM in response to Paul Elliott

It's handy sometimes to be able to copy cells from Numbers and paste them in other applications, where they appear just as they do in Numbers. Numbers does that well.

If you just want the content of the cells as text, you could use an AppleScript. That would not be complicated to write..

But first, does InDesign have an Edit > Paste Special (or similar) menu choice where you can tell it to accept the pasted material as unformatted text? One sees that in Word, for example:

SG

Reply