I've been trying to write a formula that will extract the number after the @ symbol in a number of situations, but everything I've come up with thus far won't work for every case.
Lets say in cells A1:A5 I have:
[BALL VALVE,-RF,CL600 @ 4, 10XAH007]
[BALL VALVE,-RF,CL600,SPINDLE ELONGATION @ 4...