Forum Discussion

Thomas Hewitt's avatar
Thomas Hewitt
Copper Contributor
Sep 24, 2017
Solved

Formatting filters. How do I do it?

Hi everyone. I want to format a filter so that it can pick up things with certain serial numbers if that's possible?   Essentially, I've got a column that's full of serial numbers for products but ...
  • Detlef_Lewin's avatar
    Sep 24, 2017

    Thomas,

     

    insert a helper column and filter this column.

    =LEFT(A2,3)

Resources