Explore

Citations

This is a demonstration of creating linebreaks and separating the citations into their own rows Citations Button V3

Raw Citations

Raw Citations

Name

Citations Button

Citations Button V2

Citations Button V3

Count Linebreaks

RightPad Linebreak

Notes

Tickle

Button

If I have a list of citations in one column of one row, is there a formula that will take them and put each one on a row of its own? The vastly helpful Billy_Jackson out in the Community has solved the list comparison problem we discussed, where one list was compared to another to see if there were new entries. ( I realized, as did he, we were comparing lists that existed inside the columns of a row. When you transfer the column items to be one in each row of a table, then they can be compared and the new ones noted.) So, that generates the question of creating a new row in a table for each new entry that appears in the list in the one column of one row to compare with the main list (which is a table) to see whether the new entries are already in the table, and, if not, add new rows for them. The list comes in from the text reader in one column of one row like this: BATES07235 BATES07237 BATES11175 BATES11282 BATES11285 BATES11473 BATES11508 BATES12015 But if I can convert each entry to be in its own row, then I can compare it like this: https://coda.io/d/Legal-Copy-of-Document-Comparison_dIpsXJRV3E2/Document-Comparison_suyJd

Add Citations

Add Linebreaks

Open

Tickle

Delete Non-Citations

There are no rows in this table

⁠

Citations

Citations

Name

BATES07235

BATES07237

BATES11175

BATES11282

BATES11285

BATES11473

BATES11508

BATES12015

There are no rows in this table

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.