G
GARY
COL A has 1,313 cells whose contents look like:
107211009-1
114650003-4
122413021-6
COL B has 987,601 cells whose contents look like this:
008100465-2 01 58.86
008100465-2 02 58.86
008100493-7 01 16.12
How do I find the cell(s) in COL B whose eleven left-most characters
match the contents in the cells in COL A?
107211009-1
114650003-4
122413021-6
COL B has 987,601 cells whose contents look like this:
008100465-2 01 58.86
008100465-2 02 58.86
008100493-7 01 16.12
How do I find the cell(s) in COL B whose eleven left-most characters
match the contents in the cells in COL A?