Cannot Get Needed Results Attempting to Trim

[meppwc]

I am trying to remove preceding characters in front of specific text. I have a formula but I am not getting the needed results. Can someone assist me?

The text in cell C2 is \\stlwrchprnprd01\a1_café2r2852
The formula in D2 is =RIGHT(C2,LEN(C2)-FIND("01",C2))
The result is "1\a1_café2r2852"
The needed result is "a1_café2r2852"

Note, I have a long list of values that I need to apply this formula to and every value in column C begins with \\stlwrchprnprd01\
I want to capture ONLY the value that follows \\stlwrchprnprd01\
To add to this, the value that follows \\stlwrchprnprd01\ is always a combination of letter and/or numbers but can vary in length.

 

[mikerickson]

The FIND is finding where the "01" starts. Your desired result begins 2 characters after that.

=RIGHT(C2,LEN(C2)-FIND("01",C2)+2)

Or, to protect against errors when C2 doesn't contain "01",
=RIGHT(C2,LEN(C2)-FIND("01",C2&"01")+2)

Or, the more generic
=RIGHT(C2,LEN(C2)-FIND("01",C2&"01")+LEN("01"))

 

[Joe4]

Note, I have a long list of values that I need to apply this formula to and every value in column C begins with \\stlwrchprnprd01\
I want to capture ONLY the value that follows \\stlwrchprnprd01\
To add to this, the value that follows \\stlwrchprnprd01\ is always a combination of letter and/or numbers but can vary in length.

Use this formula instead:

=TRIM(RIGHT(SUBSTITUTE(D2,"\",REPT(" ",100)),100))

This will always return whatever is after the last "", regardless of what is before it (and is not necessarily dependent on the presence of "01", and won't have issues if that exists more than once in the string).

 

[meppwc]

I think I figured it out
=RIGHT(C2,LEN(C2)-FIND("01",C2)-2)

Sorry but thanks to all who read my post.

 

[Joe4]

I think I figured it out
=RIGHT(C2,LEN(C2)-FIND("01",C2)-2)

Just note that might not work if you have any values that have "01" appear more than once in your string.
You might want to add the slash after the "01" in your find command, to make sure it only identifies that one.