Pull Text Between two characters

[JordanJS-1]

Hi All,

Im trying to pull out text between two characters.

This is the text in A1

\A1;Intersection\P11111th Avenue East & Bill Street\P\PAREA: 815.105m{\H0.7x;\S2^;}

I need to pull out everything between \P & \P

So In cell A2 I need to see 11th Avenue East & Brett Street.

Any help would be greatly appreciated.

[JBeaucaire]

In A2:

=LEFT(MID(A1, SEARCH("\P",A1)+2, LEN(A1)),SEARCH("\P",MID(A1, SEARCH("\P",A1)+2, LEN(A1)))-1)

[oeldere]

if all data is the same, you can use text to column in Excel and use the / as seperator.

Your data is in column B.

[JordanJS-1]

Thank you! Unfortunately all my data was different

[Bo_Ry]

Please try
=TRIM(MID(SUBSTITUTE(A1,"\P",REPT(" ",300)),300,300))