text and number

Wade · Mar 12, 2010

i have something like this in a cell:

T2 T2 E1 T2 N3

can I add just the numbers and put the answer(10) in an adjacent cell and
disregard the text?

Wade · Mar 14, 2010

that works - can i make it do that automatically to a cell?

thanks!

wade