I used the TEXTBEFORE function to capture everything before that last dash. The argument for text is the list of SKU numbers, which is A2:A14 in this scenario, and the argument for delimiter is “-“.

D espite its age, Excel continues to evolve with new functions being added over time. There are newer better Excel functions ...

A. TEXTSPLIT is a very useful function for breaking down text cells that contain different lengths of text and delimiters. It can be used in several ways, and we’ll review some examples of how to use ...