Thread: text and number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wade Wade is offline
external usenet poster
 
Posts: 22
Default text and number

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?