Assuming that there will be at least one space character in every cell entry...from the right I need to know where the last space is.
For example
xxxxxx xxxxxx=7
xxx xxxxx=6
xxxxx x=2
what is the formula that will give me the value?
Function FSFR(str As String) As String
FSFR = Mid(str, InStrRev(str, " "))
End Function