Thread: OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
View Single Post
  #6   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
Forget that one

"Niek Otten" wrote in message ...
| =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