Filter columns with a specific string

[Amit Dubey]

Hi All,

I want to filter columns from an excel spreadsheet where the value in the cells contains/includes the String "Create". Pls help me with this.

Best regards,
Amit

 

[RonB1111]

Select your header cells and turn on excel auto filters. (Data-Filter). See: http://www.contextures.com/xlautofilter01.html

Now click on the small triangle that appeared in the header cell and select Custom Text Filter, then in the custom window select "Contains" from the drop down list on the left side and on the right side enter the word Create and click OK.

 

[Amit Dubey]

Thanks a ton

Best regards,
Amit

 

[RonB1111]

You're welcome. Thank you for the feedback.