Thread
:
OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
View Single Post
#
3
Posted to microsoft.public.excel.programming
GTVT06
external usenet poster
Posts: 141
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),"")
Reply With Quote
GTVT06
View Public Profile
Find all posts by GTVT06
OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT