| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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),"") |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 | | |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Test left character is a number? | Excel Discussion (Misc queries) | |||
| Return a 3 digit number | Excel Worksheet Functions | |||
| Change a 1,2,3 or 4 digit number to a 6 character text string | Excel Worksheet Functions | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| Find max number of character and return cell address | Excel Worksheet Functions | |||
Hybrid Mode
