Pull text from the left of a character to the right of the next character foun

[Ingolf]

Hi,

Give us more examples.
With given examples, use one of the following formulas:

=SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("-",A1)+1),"^","")
or
=SUBSTITUTE(RIGHT(A1,5),"^","")

[briguy22]

Hi,

Give us more examples.
With given examples, use one of the following formulas:

=SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("-",A1)+1),"^","")
or
=SUBSTITUTE(RIGHT(A1,5),"^","")

aab*532*.3*apple^
aaac*53268*.598*-car^
george*ford*678*banana^
rifle*car*.705*@exclamation^

results would need to be:

apple
-car
banana
@exclamation

[Ingolf]

OK.

Try this formula:

=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1,"*",REPT(" ",50)),30)),"^","")

or

=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A1,"^",""),"*",R EPT(" ",50)),30))