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 “-“.
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 ...
How to use the new TEXTSPLIT() function in Microsoft Excel Your email has been sent Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating or returning a character ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback