I have Cells that have nonspecific symbols in the middle of the text, and would like to filter and reorder the cells based on the text in the middle.
If names got reformatted like such, but where scattered about in a long list of names, how would I go about finding them.
bobjsmith
johnklogan
georgewbush
michaelsbuble
michaeljjackson
Is there a way to format the filter to say ""j"" gets highlighted or changed to bob j smith
Thank you in advance.
Bookmarks