RIGHT Arguement?

S

Saxman

If the number 123456 was displayed in cell A1, how could I get the fifth
digit (5) displayed in cell A2?

TIA
 
M

Marcelo

Hi

=mid(a1,5,1)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Saxman" escreveu:
 
C

CLR

You're welcome, just keep in mind that the basic formula
=MID(A1,5,1)
will return a TEXT version of the 5th character, whereas this version
=MID(A1,5,1)*1 will convert it back to Numerical

Vaya con Dios,
Chuck, CABGx3
 
J

Jim May

Another thought:

The =MID(A1,5,1) return the 5 as text (the 5 would be in a text format);
You could enclose the above inside the Value() functions to convert it
(the 5) back to a number or you could use the -- (two minus characters)
like so:
--Mid(A1,5,1) << This also convert text to a true number.

FWIW,

Jim May
 
R

Roger Govier

Hi

I can't see the earlier thread, but if Chuck's answer of
=MID(A1,5,1)
is what you want to include within parentheses, then
="("&MID(A1,5,1)&")"

should do what you want.
 
Top