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