Extract the text value

Exacting the range and readability from the instrument type  How to extract it please guide me i filter the data( please refer the other sheet) and try to extract. In this method is correct or no...