T
TPG
I have data files (12 digits numbers) in ascending order under column A and I
need to keep data that only fall under certain numbers in position 2 to 4,
(eg. 453 for Column A1,A2,A3 and 560 for Column A6), the rest will be deleted
off. Thanks.
A
1 245301020915
2 245301020931
3 245301020952
4 245701020959
5 249651010081
6 256051017001
7 256051017002
need to keep data that only fall under certain numbers in position 2 to 4,
(eg. 453 for Column A1,A2,A3 and 560 for Column A6), the rest will be deleted
off. Thanks.
A
1 245301020915
2 245301020931
3 245301020952
4 245701020959
5 249651010081
6 256051017001
7 256051017002