RIGHT Arguement?
 

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

TIA

RIGHT Arguement?
 

=MID(A1,5,1)*1

Vaya con Dios,
Chuck, CABGx3




"Saxman" wrote:

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

TIA

RIGHT Arguement?
 

Hi

=mid(a1,5,1)

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



"Saxman" escreveu:

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

TIA

RIGHT Arguement?
 

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

=MID(A1,5,1)
--
David Biddulph

RIGHT Arguement?
 

David Biddulph wrote:

=MID(A1,5,1)

It works fine!

Thanks everybody.

RIGHT Arguement?
 

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



"Saxman" wrote:

David Biddulph wrote:

=MID(A1,5,1)

It works fine!

Thanks everybody.

RIGHT Arguement?
 

Hi,

=Mid(A1,5,1)

Cheers
Carim

RIGHT Arguement?
 

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





"Saxman" wrote in message
:

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

TIA

RIGHT Arguement?
 

Is there a key for how to place letters/numbers between parenthesis to return
an answer?



"CLR" wrote:

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



"Saxman" wrote:

David Biddulph wrote:

=MID(A1,5,1)

It works fine!

Thanks everybody.

RIGHT Arguement?
 

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.

--
Regards

Roger Govier


"jrivel" wrote in message
...
Is there a key for how to place letters/numbers between parenthesis to
return
an answer?



"CLR" wrote:

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



"Saxman" wrote:

David Biddulph wrote:

=MID(A1,5,1)

It works fine!

Thanks everybody.

RIGHT Arguement?
 

Hi Jrivel..........
The "key" you are asking about is called the "syntax". Each function has
one. Here is the one from the Excel Help on the MID function.........
************************
Returns a specific number of characters from a text string, starting at the
position you specify.

Syntax
MID(text,start_num,num_chars)
Text is the text string containing the characters you want to extract.
Start_num is the position of the first character you want to extract in
text. The first character in text has start_num 1, and so on.

· If start_num is greater than the length of text, MID returns "" (empty
text).
· If start_num is less than the length of text, but start_num plus num_chars
exceeds the length of text, MID returns the characters up to the end of text.
· If start_num is less than 1, MID returns the #VALUE! error value.

Num_chars specifies how many characters to return from text. If num_chars
is negative, MID returns the #VALUE! error value.

Examples
MID("Fluid Flow", 1, 5) equals "Fluid"
MID("Fluid Flow", 7, 20) equals "Flow"
MID("1234", 5, 5) equals "" (empty text)


hth
Vaya con Dios,
Chuck, CABGx3





"jrivel" wrote:

Is there a key for how to place letters/numbers between parenthesis to return
an answer?



"CLR" wrote:

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



"Saxman" wrote:

David Biddulph wrote:

=MID(A1,5,1)

It works fine!

Thanks everybody.