OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
 

OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT

OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
 

Do you want a formula?

=MID(A1,2,1)

HTH,
Paul

--

"BIGE" wrote in message
...
OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT

OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
 

On Apr 3, 3:04*pm, BIGE wrote:
OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT

Assuming the 4 digit number is in cell A1

=IF(LEN(A1)=4,MID(A1,2,1),"")

OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
 

If the number is in A1: =MID(A1,2,1)

Hope this helps,

Hutch

"BIGE" wrote:

OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT

OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
 

=LEFT(A1,2,1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BIGE" wrote in message ...
| OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT

OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
 

Forget that one

"Niek Otten" wrote in message ...
| =LEFT(A1,2,1)
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "BIGE" wrote in message ...
|| OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
|
|

OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
 

On Apr 3, 3:04*pm, BIGE wrote:
OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT

I guess the function "LEFT" should help
Assuming the number is in A1,
=LEFT(A1,2,1)

Regards,
S.

OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
 

Here's another way:
=MOD(INT(A1/100),10)

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"BIGE" wrote in message ...
OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT