Try this:

=MID(A1,3,1)

--
Biff
Microsoft Excel MVP


"Lowan Chan" wrote in message
...
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