refer to text

  • Thread starter Thread starter Lowan Chan
  • Start date Start date
L

Lowan Chan

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.
 
Use MID() and LEN()

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

Where 5 is the number from the right.

If this helps, please click "Yes"
<><><><><><><><><><>
 
thanks a lot. It helps. But seems doesn't work on my case. For example:
12,345.60 in A1, in b1, I want to display "0", which is the last digit of
12,345.60. so I set

=mid(a1, len(a1)-0, 1)

the answer comes to "6" in stead of "0". How can I change the formula to get
"0"?

thanks in advance.
 
Thanks T. Valko. The answer only let me get "0", but cannot get 6, 5.... as
I need to get each digit seperately. Can you help what should I do?

Thanks a lot.
 
Excel doesn't recognize terminating 0s in decimal numbers.

The only way you can see them is if you use a number format set to a certain
number of decimal places. For example:

10.00

To Excel, the .00 does not exist. It is only there for *display purposes* IF
you format the cell to display the 2 decimal places. If you select the cell
that contains 10.00 and look in the formula bar you will see10 not 10.00.
That's because those .00 don't really exist.

So, with this in mind perhaps we need a better idea of what you're trying to
do.
 
Back
Top