Forum Discussion
Solved
Formula to separate text into by specific character
Hello, I have a String of Text that I would like to separate using a formula vs Txt -> Column. Here is a Sample 03-08-2822 - Marc' Pizza - Pittsburgh, PA - 181 I want to separate at the 3rd...
I assume the numbers in the beginning are the same length. If so please find the excel implementation.
provide me with feedback if needed.
As variant
=TRANSPOSE(FILTERXML("<r><n>" & SUBSTITUTE(A4,"- ","</n><n>") & "</n></r>", "//n"))