How to filter dr & cr. in excel from tally exported data

1) Place your cursor on cell D3 and go into the Define Name (Formulas -> Define Name/Name Manager)
2) Ener Name as "CRDR" (of your choice if you want) and under "Refers to" enter this formula =Get.cell(7,!C3)
3) On Cell D3, enter =CRDR, this should display the custom format applied on the cell like (0.00 "DR").
4) Enter the same formula =CRDR on all the Cells on D column
5) Apply autofilter on the D column, using custom filters, filter as desired.