lookup second character

Ron · May 13, 2005

I have:
ABC

I want to find the second character only and put it in a different cell.
Example
B

Thanks

William · May 13, 2005

Ron

In the cell where you want to return "B", enter
=MID(A1,2,1)
where cell A1 contains "ABC"

--

XL2003
Regards

William
[email protected]