Paste content from one InDesign table to another, without formatting?

Community Beginner ,
Nov 24, 2020 Nov 24, 2020

Copy link to clipboard

Copied

So, I need to copy text content from one InDesign table and paste into another table with different text formatting [different font, colour, size etc]. The problem I've got is if I highlight the original table and copy, InDesign doesn't allow Paste without Formatting.

 

If I copy text contained WITHIN a cell in the InDesign table, and paste into a separate table, Paste without Formatting works fine.

 

I'm guessing the issue is because when I highlight the entire original table, and copy, I'm not only copying the text formatting but the table formatting too?

 

Anyway, is there a way around this...I really don't want to have to copy and paste each bit of text separately! Would it be I just need to paste in the content with the original formatting and then apply my new Styles to it?

TOPICS
How to, Print, Type

Views

180

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct Answer

Adobe Community Professional , Nov 24, 2020 Nov 24, 2020
My workaround is to convert the table you want to copy from to text. Then you will be able to copy the needed lines, highlight the rows they go into, and Paste without formatting will work.

Likes

Translate

Translate
Adobe Community Professional ,
Nov 24, 2020 Nov 24, 2020

Copy link to clipboard

Copied

My workaround is to convert the table you want to copy from to text. Then you will be able to copy the needed lines, highlight the rows they go into, and Paste without formatting will work.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Nov 24, 2020 Nov 24, 2020

Copy link to clipboard

Copied

Ah yes, that appears to work!

 

I would of imagined the convert table text would of pasted into one cell, as appose to separate cells...but it doesn't!

 

Sweet, thank you 🙂

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Nov 24, 2020 Nov 24, 2020

Copy link to clipboard

Copied

Hi Susan,

 

Without wanting to be unpleasant [you know me and you know I'm so cool!  😉 ], and even if it is a workaround, I am not really convinced!

 

[Time to eat; explanations later!]

 

(^/)  The Jedi

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Nov 24, 2020 Nov 24, 2020

Copy link to clipboard

Copied

I use this trick often - it gets the job done. 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Nov 24, 2020 Nov 24, 2020

Copy link to clipboard

Copied

These 2 scripts too! …

 

Associating the 2 Scripts to 2 keyboard shortcuts, as Ctrl-C, for "copying" and Ctrl-V, for "pasting" (even if I absolutely don't use copy-paste [funny!] in the scripts), the game can begin!

 

 

(^/)

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Nov 25, 2020 Nov 25, 2020

Copy link to clipboard

Copied

Hi FRIdNGE,

 

Very nice. Where might these scripts be available, if you don't mind me asking?!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Nov 24, 2020 Nov 24, 2020

Copy link to clipboard

Copied

Hi blackberryd1991,

my workaround is:

 

[1] Select the table cells and copy them to the clipboard.

Switch to Excel.

[2] Paste to a single cell selected in a new Excel spreadsheet.

[3] Copy the selected cells to the clipboard.

Switch to InDesign.

[4] Select a single table cell in InDesign

[5] Paste the contents of the clipboard.

 

Just tested this successfully with my German InDesign 2021 and old Excel from Office 2010 on Windows 10.

 

Regards,
Uwe Laubender

( ACP )

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Nov 25, 2020 Nov 25, 2020

Copy link to clipboard

Copied

Hi,

 

I did give that a go, but I'm finding if my cell [in InDesign] conatins more than one word, when I paste into Excel is puts the words into seperate cells ;(

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Nov 25, 2020 Nov 25, 2020

Copy link to clipboard

Copied

LATEST

Hi blackberryd1991,

did some more tests. Switching between InDesign and Excel is working as expected as long as a table cell does not contain more than one paragraphs or a tab special character. And of course other special characters as auto page number, footnote or endnote will not be transferred as well. Also not anchored objects.

 

Regards,
Uwe Laubender

( ACP )

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines