SOLVED

Formula to separate text into by specific character

Copper Contributor

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 - 18103-08-2822Marc' PizzaPittsburgh, PA181

 

Any help would be appreciated 

3 Replies
best response confirmed by UniversalAtlantic (Copper Contributor)
Solution

@UniversalAtlantic 

 

I assume the numbers in the beginning are the same length. If so please find the excel implementation.

provide me with feedback if needed.

@Ramiz_Assaf 

 

This is exactly what I'm looking for thank you 

@UniversalAtlantic 

As variant

=TRANSPOSE(FILTERXML("<r><n>" & SUBSTITUTE(A4,"- ","</n><n>") & "</n></r>",  "//n"))
1 best response

Accepted Solutions
best response confirmed by UniversalAtlantic (Copper Contributor)
Solution

@UniversalAtlantic 

 

I assume the numbers in the beginning are the same length. If so please find the excel implementation.

provide me with feedback if needed.

View solution in original post