excel info

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I would like to isolate specific digits in excel. i.e.
If I had 1789A2 in a cell, I would like to only display
the fourth digit from the left
 
=MID(A1,4,1) if you want it back as text, or =--MID(A1,4,1) if you want it as numeric.
 
Back
Top