Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete unwanted records
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete unwanted sheet | Excel Discussion (Misc queries) | |||
Delete unwanted data | Excel Worksheet Functions | |||
macro to delete unwanted data | Excel Discussion (Misc queries) | |||
Delete unwanted page breaks. | Excel Worksheet Functions | |||
Delete Unwanted Data | Excel Discussion (Misc queries) |