ExcelBanter - Filter substring of a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filter substring of a cell (https://www.excelbanter.com/excel-discussion-misc-queries/214459-filter-substring-cell.html)

GregNga

Filter substring of a cell

How can I filter only cells that contain a certain substring, Example, I want
to display only cells that contain the sting FDW. This would be for

Excel 2000 (unfortunately)

Gord Dibben

Filter substring of a cell

Autofilter on Custom "contains"

Gord Dibben MS Excel MVP

On Mon, 22 Dec 2008 13:31:01 -0800, GregNga
wrote:

How can I filter only cells that contain a certain substring, Example, I want
to display only cells that contain the sting FDW. This would be for

Excel 2000 (unfortunately)

All times are GMT +1. The time now is 07:15 PM.