View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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