How to Split Text Separated by Carriage Return In
Without Office365, FILTERXML is a good substitute for the TEXTSPLIT function
What you need to understand first is:
1. XML structure
2. XPath
Here is a simple example
Without Office365, FILTERXML is a good substitute for the TEXTSPLIT function
What you need to understand first is:
1. XML structure
2. XPath
Here is a simple example