Sep 14 2020 08:34 AM
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
Sep 14 2020 08:56 AM
Solution
I assume the numbers in the beginning are the same length. If so please find the excel implementation.
provide me with feedback if needed.
Sep 14 2020 09:03 AM
Sep 14 2020 10:39 AM
As variant
=TRANSPOSE(FILTERXML("<r><n>" & SUBSTITUTE(A4,"- ","</n><n>") & "</n></r>", "//n"))
Sep 14 2020 08:56 AM
Solution
I assume the numbers in the beginning are the same length. If so please find the excel implementation.
provide me with feedback if needed.