Use MID() and LEN()

=MID(A1,Len(A1)-5,1)

Where 5 is the number from the right.

If this helps, please click "Yes"
<<<<<<<<<<

"Lowan Chan" wrote:

thanks. How about if I want to count it from right?

thanks.
--
Lowan


"Jacob Skaria" wrote:

Use MID()

=MID(A1,3,1)

If this post helps click Yes
---------------
Jacob Skaria


"Lowan Chan" wrote:

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