Thread: OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
  
Posts: 3
Default 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.
Reply With QuoteReply With Quote