text and number

W

Wade

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use array for lookup value, to return array of lookups 4
MROUND time 2
Checking status of issues based on first two digits of a field 7
Formula/Function Question 2
Checking on first two digits of field 5
IF Dilema detail 6
ONLY IF 6
Combining a constant and a cell value in one cell 1

Top