The issue is your formula is not finding the last space. Each find in your formulas is just finding the position of the first space.
In the sheet below column C shows what your formula is actual calculating. Notice every find is returning the same number. Also if you look at your formula in B! on post 1 it actual returns a space before test4.
Your formula in post 4 will not work for the same reason.