| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Filtering Data
Dear All I have a problem could somebody please help? I have a list of data and I would like to filter it buy removing the first 4 characters DHK-6000 DHK-6000. DHK-6000HD DHK-6000HDB SZK-6001 SZK-6001. RVK-6002 RVK-6002. To make it look like this 6000 6000. 6000HD 6000HDB 6001 6001. 6002 6002. As I have thousands of these I do not want to do this manually Also once I have done this how do I filter the data so that it does not display any data containing a B. Answers to either question would be much appreciated. Thanks Andrew -- koba ------------------------------------------------------------------------ koba's Profile: http://www.excelforum.com/member.php...o&userid=28639 View this thread: http://www.excelforum.com/showthread...hreadid=483692 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching data in tables - Filtering | Excel Discussion (Misc queries) | |||
| Filtering Columns to Align Matching Data | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Filtering out Data | Excel Discussion (Misc queries) | |||
| Filtering data in Excel for mailmerge to Word | Excel Discussion (Misc queries) | |||
Threaded Mode
