Look at the example I have below.
A-.375-VG-M761 A-.375-VG-O630 A-.375-VG-O780 A-.75-VG-602 A-.75-VG-603 A-.75-VG-604
In one column I have two "SKUs": A-.375-VG and A-.75-VG.
I want to use this data to separate these SKUs onto two specific tabs of the same sheet.
How do I search through a column and return a cell if it contains a certain string of text?
I've tried REGEXMATCH and FIND but neither of those seem to do the trick.