Hi,

I have a text, e.g. "Finished" in A1, if I want the 3rd word from left "n"
be displayed in B1, how to make the formula? and if A1 is a number, e.g.
12,520.70, how can a formula to display "5" in B1?

thanks in advance.
--
Lowan