Excel How to Sort or filter text by specific word or words

0 votes
Even if the term is used in a sentence in the cell, it may still be able to organize, sort, or filter a column based on that word. For instance, I want to arrange the columns in my image according to the phrase "elephant." Therefore, the elephant-themed cell will be at the top. Better yet, sort the column by two words that appear in the same sentence, for example, elephant and dog in the cell with Tower, elephant, and dog.

Is it possible, and if so, how?
Nov 27, 2022 in Others by Kithuzzz
• 38,020 points
569 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

How to add text on new page in word doc via excel vba

First start with: objDoc.Range.Insertafter vbCr & Chr(12) & ...READ MORE

answered Nov 25, 2022 in Others by narikkadan
• 63,720 points
1,830 views
0 votes
1 answer

How to access entire row by cell address or value in excel?

You may accomplish all of this by ...READ MORE

answered Dec 28, 2022 in Others by narikkadan
• 63,720 points
1,332 views
0 votes
1 answer

How to scrape the specific text from kworb and extract it as an excel file?

The best practice to scrape tables is ...READ MORE

answered Feb 18, 2023 in Others by narikkadan
• 63,720 points
672 views
0 votes
0 answers

Excel 2010, how to keyboard shortcut to filter dropdown checkboxes?

how do I get to the filter ...READ MORE

Feb 10, 2022 in Others by Edureka
• 13,690 points
303 views
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
5,159 views
0 votes
1 answer

Disable Sorting in excel

Go to the Home ribbon, click the ...READ MORE

answered Jun 9, 2022 in JQuery by gaurav
• 23,260 points
437 views
0 votes
1 answer

Sort Excel worksheets based on name, which is a date

Sorting sheets of a workbook are rather ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 63,720 points
518 views
0 votes
1 answer

How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

Use SORTBY, e.g. =SORTBY(A2:B5,A2:A5,1,B2:B5,1) Or simply&nb ...READ MORE

answered Jan 22, 2023 in Others by narikkadan
• 63,720 points
477 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP