How do the TEXTBEFORE and TEXTAFTER functions in Excel work ... 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 ...