Formula for removing characters before or after a specific symbol or phrase

[funguy]

any assistance would be really appreciated , thanks !

 

[JackDanIce]

Try:

=TRIM(RIGHT(A1,LEN(A1)-FIND(" -in- ",A1)-5))

 

[Andrew Poulsom]

Try:

=RIGHT(A1,LEN(A1)-(FIND("-in- ",A1)+LEN("-in- ")-1))

 

[funguy]

it didn't seem to work. It just says " #VALUE! "
</pre>

 

[funguy]

They both worked ! thanks a ton

 

[Rick Rothstein]

If your text always has "-in-" in it (lower case is important) and you want the text after it, then maybe this formula will work for you...

=TRIM(RIGHT(SUBSTITUTE(A1,"-in-",REPT(" ",999)),999))