Return Characters After A String of Characters in Excel

[gemmavine]

Hi

I have lots of strings of data in column A, first cell being A2

However, they end all in "~p~" followed by a number

I want excel to find ~p~ and return the characters after it.

I have tried a few formulas =right, left, mid, find etc but can't figure it out.

Thanks in advance
Gemma

 

[Joe4]

Try this:

=TRIM(RIGHT(SUBSTITUTE(A2,"~p~",REPT(" ",LEN(A2))),LEN(A2)))

 

[gemmavine]

Thank you so much Joe and thanks for the speedy response
Regards
Gemma

 

[Joe4]

You are welcome.
Glad I was able to help!