lookup second character
 

I have:
ABC

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


Thanks

Ron

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

--


XL2003
Regards

William



"Ron" wrote in message
...
I have:
ABC

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


Thanks