Thread: How to extract numbers from letters in cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How to extract numbers from letters in cell?
In cells A1 thru E1 enter:
abc123
=RIGHT(A1,3)
=LEFT(A1,1)
=MID(A1,2,1)
=MID(A1,3,1)

--
Gary''s Student - gsnu200798
Reply With QuoteReply With Quote