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 4th and 5th "-" dash VIA FORMULA
so my sheet would look like this
| 03-08-2822 - Marc' Pizza - Pittsburgh, PA - 181 | 03-08-2822 | Marc' Pizza | Pittsburgh, PA | 181 |
Any help would be appreciated
I assume the numbers in the beginning are the same length. If so please find the excel implementation.
provide me with feedback if needed.
3 Replies
As variant
=TRANSPOSE(FILTERXML("<r><n>" & SUBSTITUTE(A4,"- ","</n><n>") & "</n></r>", "//n"))I assume the numbers in the beginning are the same length. If so please find the excel implementation.
provide me with feedback if needed.
