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

's Computer Specifications

's Computer Specifications

Do you want a formula?

=MID(A1,2,1)

HTH,
Paul

--

"BIGE" <(E-Mail Removed)> wrote in message
news:A595F8AB-A367-41F0-A7E9-(E-Mail Removed)...
> OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT

's Computer Specifications

On Apr 3, 3:04*pm, BIGE <B...@discussions.microsoft.com> 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),"")

's Computer Specifications

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

's Computer Specifications

=LEFT(A1,2,1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BIGE" <(E-Mail Removed)> wrote in message news:A595F8AB-A367-41F0-A7E9-(E-Mail Removed)...
| OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT

's Computer Specifications

Forget that one

"Niek Otten" <(E-Mail Removed)> wrote in message news:O$(E-Mail Removed)...
| =LEFT(A1,2,1)
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "BIGE" <(E-Mail Removed)> wrote in message news:A595F8AB-A367-41F0-A7E9-(E-Mail Removed)...
|| OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
|
|

's Computer Specifications

On Apr 3, 3:04*pm, BIGE <B...@discussions.microsoft.com> 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.

's Computer Specifications

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

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

"BIGE" <(E-Mail Removed)> wrote in message news:A595F8AB-A367-41F0-A7E9-(E-Mail Removed)...
> OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Return a 3 digit number	Patrick C. Simonds	Microsoft Excel Worksheet Functions	2	30th Jan 2009 07:35 AM
return all after specific character. left, right, mid???	Scubadaisy	Microsoft Access Queries	5	24th Apr 2008 08:42 PM
Change a 1,2,3 or 4 digit number to a 6 character text string	Steve D	Microsoft Excel Worksheet Functions	3	28th Mar 2008 08:14 PM
Test left character is a number?	=?Utf-8?B?bmFzdGVjaA==?=	Microsoft Excel Misc	6	20th Sep 2007 04:30 AM
trimming left digit of a number	=?Utf-8?B?U2NvdHQ=?=	Microsoft C# .NET	2	3rd Nov 2004 09:23 AM