I have used the Excel functions LEFT ... We can again use TEXTSPLIT to separate this information. You can enter multiple delimiters into the argument Col_delimiter. You must put curly brackets around ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback