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