Split substring before and after special characters

Hi Everyone

I have a input table as Sheet1, i want to check and split into one by one item as output sheet2.

How to do this.

Thanks in advance!
Split string.xlsx (8.7 KB)

Try this

SplitSubstring.xaml (11.4 KB)

1 Like

Thanks you very much!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.