excel info

[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

 

[Phobos]

=MID(A1,4,1)

P

 

[Ken Wright]

=MID(A1,4,1) if you want it back as text, or =--MID(A1,4,1) if you want it as numeric.

 

[Peo Sjoblom]

=MID(A1,4,1)

add a + if you want it to be numeric

=MID(A1,4,1)+0