Excel: Using the MID function in a concatenate to find a median

[Pro33]

I am having no luck using the mid function inside a concantenation. I am trying to find the median and average inside a concantenation using the mid function:
AM
101110
231123
123411

=median(mid(am1:am3,3,2))
????

I've created a concatenation in AM. I now need to take values in each string and find the median of those values. I am using the mid function to take out the value but I need to do it for an entire column.

 

[SkipVought]

hi,

You cannto do arithmetic on STRINGS.
[tt]
=MEDIAN(VALUE(MID(AM1:AM3,3,2)))
[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lionelhill]

Note that Skip's formula must be entered as an array formula if you want the median of the two middle digits of each number. If you enter it as written, it returns the middle digits of the first cell irrespective of their value (or the value of any other cell).