Many times I received the query from our excel users asking how to filter the text with bold character, but unfortunately, there is no direct way in the filter option
So here we provide a small trick to filter the bold text only by using Find option.
Step-1
Press Ctrl+F Key or Find option and click on the Format option, and click on Font option and select bold and press ok
Click on the Find All option, Now select the area which is having bold character by typing Ctrl+A
Step-2
And fill the selected cells with color, Filter the column with color
Step-3
Copy the text and paste it in the other column.
Video Link: Watch Video