Hi - Dave here.
Last week, I shared a formula to
split dimensions into separate values.
This week, I have a more generic example: how to split comma-separated text into separate cells. The "before" formula uses a nerdy FILTERXML trick:
The "after" formula, based on TEXTSPLIT, is dead simple:
[
download the workbook and read the full explanation]
Another good example of how new Excel functions really simplify things!
TEXTSPLIT only works in Excel 365, but the FILTERXML formula above works in older versions of Excel on Windows. Both approaches are explained in the article, which includes the workbook. Download the workbook and have a look.
Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a fun and safe weekend!
Dave
