Home |
Search |
Today's Posts |
#1
|
|||
|
|||
lookup second character
I have:
ABC I want to find the second character only and put it in a different cell. Example B Thanks |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Lookup Lookup | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |