I am trying to split text by a delimiter, but I want the delimiter to remain. It does not seem to work. I want the text to split text by "CZ" in this example.
Is there a way to do this?
Is there a way to do this?
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B10 | B2 | =TEXTSPLIT(A2,,"CZ") |
Dynamic array formulas. |