• 

  Megan Butler

  • May 11, 2022 20:31

  Interesting question! If I understand it, you have one source link that is currently:

     [Common Narrative Paragraph A

     Common Narrative Paragraph B

     Common Narrative Paragraph C]

  and you want a second source link that is just:

     [Common Narrative Paragraph A

     Common Narrative Paragraph B]

  and I figure you also would want this second one to update if you update the first set of paragraphs? 

   

  This is technically possible through some table and formula usage, but really clumsy to do and with a big limitation:

  Create a table that is one column and two rows. Link the existing 3 paragraph link into the first cell. In the second cell, use the formulas as follows:
  =TRIM(SUBSTITUTE("A1","Common Narrative Paragraph C",""))
  where A1 is the first cell in the table and "Common Narrative Paragraph C" is the entire text of the paragraph you want to eliminate. 
  You can then copy this and paste into text and it is a new source link.

  This is, however, not ideal, since you would have to Common Narrative Paragraph C update within the formula if you made changes to Common Narrative Paragraph C, but technically possible. Illustration:

  

  What is worth noting from this solution is that you can use table cells to put together destination links into a new source link. - if you had that common narrative as separate links, you could combine them in different ways in table cells to link out to your further destinations. Works better if all of the pieces are in the same file - if you have one piece coming from a spreadsheet to a document linking to another document, you have to remember to publish in both sources.  Illustration:

  

   

   

  2

Please sign in to leave a comment.