Average using alphanumerics

[Guest]

I have places in a spreadsheet column 1st, 2nd, 3rd... How do I get an
average to show those alphanumeric characters? I can do straight numerals but
with the alpha included it has me baffled, which doesn't take much...
Thanks!

 

[Frank Kabel]

Hi
nay chance to stripe the alpha characters from your values

 

[Biff]

Hi!

Assuming that these are all typical ordinal numbers, try
this array formula and enter with the key combo of
CTRL,SHIFT,ENTER:

=AVERAGE(--LEFT(A1:A10,LEN(A1:A10)-2))

Biff

 

[Guest]

Yes, I can strip them but was wondering if there was a way to show. I guess I
could create a work area that defines 1=1st, 2=2nd and so on...

 

[Guest]

Thanks Biff, I'll try it in the morning... 11:47 PM here in Kent, WA and I
gotta get up in a few hours.
Thanks again!