I want to use the Find function but I want to get the result going
from right to left. For example if I am searching for a space " ",

Steve Scott 75 - I want the find to return 3 NOT 6
Al Smith 4 - I want the find to return 2 Not 3

How can I modify this

FIND(" ",A1)

Thanks