Digital White Papers

LPS20

publication of the International Legal Technology Association

Issue link: https://epubs.iltanet.org/i/1310179

Contents of this Issue

Navigation

Page 29 of 51

I L T A W H I T E P A P E R | L I T I G A T I O N A N D P R A C T I C E S U P P O R T 30 Press Enter and voilà – the value has now been appended to the row: Continue with following columns to the right on the same row, taking care to update the row number for the value: Once all values have been appended to the first row, you can copy down to the last row by highlighting the new values just added and double-clicking on the bottom right-hand Fill Cell Handle: This will carry the formula down through the list on sheet 1: Important Note: Depending on what the information is destined for, you may want to copy and past the values to replace formulas with text values. CONVERT DATE Dates can be a really tricky problem in Excel. Most often, changing the Date format can remedy the problem, but sometimes, the date has been entered as text and can be difficult to convert. the following article describes how to convert a text entered date into a properly formatted date: https://exceljet. net/formula/convert-text-to-date

Articles in this issue

Links on this page

Archives of this issue

view archives of Digital White Papers - LPS20