I placed my cursor in cell B2, where I want the SKU numbers without color to appear. I used the TEXTBEFORE function to capture everything before that last dash. The argument for text is the list of ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results