Forum Discussion
Thomas Hewitt
Sep 24, 2017Copper Contributor
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 ...
- Sep 24, 2017
Thomas,
insert a helper column and filter this column.
=LEFT(A2,3)
Detlef_Lewin
Sep 24, 2017Silver Contributor
Thomas,
insert a helper column and filter this column.
=LEFT(A2,3)
Thomas Hewitt
Sep 24, 2017Copper Contributor
Thanks for coming back to me Detlef. I appreciate your help.
You've solved my problem and for that you're an absolute star. Thanks very much.