Hi All, I'm using a piece of code that returns the last term in a string, which here is the number 44.

Where the following string is in D101:
AAPL May21 44

The following code returns the 44:
=TRIM(RIGHT(SUBSTITUTE(D101," ",REPT(" ",100)),100))

This seems to work fine but I keep getting a circular references error message a few times an hour.

unnamed.png

Does anyone know why or an error free way to do this?