Use Filter function with IsText and IsNumber function to filter your text in seconds. Filter function filters text based on a certain criteria: Filter(Data you want to filter, Criteria to filter) IsText checks whether the selected data is text or not IsNumber checks whether the selected value is a number or not ❤️ and follow @sheetsensei for daily tips 🗂Don’t forget to save this for future reference Share it with your Excel pro friend🤓 #excel #msexcel #exceltips #corporatelife #accounting #elearning #learn #spreadsheet #spreadsheets #worksmart #worklikeaboss #consultinglife