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


Reply With QuoteReply With Quote