ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Tshortened barcode digits
barcode # to enter in LS2 report
2
T1T 1
3
T2T 2
4
T3T 3Instructions:
5
T4T 4
1) Copy and paste as many "T"s in column A, as needed.
6
T5T 5
2) Fill down consectutive numbers in column B, as appropriate to shortened barcode #s in collection.
7
T1000T 1000
(To do this, type at least 3 consecutive numbers in vertical cells in column B.
8
T1001T 1001
Highlight the consecutive numbers. Click and hold the square icon at the bottom, right of the highlighted numbers.
9
T1002T 1002
Drag the square down column B then release.)
10
T1003T 1003
3) Copy and paste the "formula" in cell C to all other empty cells in column C. Example "formula" is A2&" "&B2.
11
T1004T 1004
4) Copy all barcode #s in column C. Paste in LS2 Report.
12
T1005T 1005
NOTE: Only shortened barcode #s that exist in the collection will appear in the report.
13
T1006T 1006
RECOMMENDED to work with sets of 50 barcode #s.
14
T1007T 1007
15
T1008T 1008
16
T1009T 1009
17
T1010T 1010
18
T1011T 1011
19
T1012T 1012
20
T1013T 1013
21
T1014T 1014
22
T1015T 1015
23
T1016T 1016
24
T1017T 1017
25
T1018T 1018
26
T1019T 1019
27
T1020T 1020
28
T1021T 1021
29
T1022T 1022
30
T1023T 1023
31
T1024T 1024
32
T1025T 1025
33
T1026T 1026
34
T1027T 1027
35
T1028T 1028
36
T1029T 1029
37
T1030T 1030
38
T1031T 1031
39
T1032T 1032
40
T1033T 1033
41
T1034T 1034
42
T1035T 1035
43
T1036T 1036
44
T1037T 1037
45
T1038T 1038
46
T1039T 1039
47
T1040T 1040
48
T1041T 1041
49
T1042T 1042
50
T1043T 1043
51
T1044T 1044
52
T1045T 1045
53
T1046T 1046
54
T1047T 1047
55
T1048T 1048
56
T1049T 1049
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100