View Single Post
  #1   Report Post  
Arturo
 
Posts: n/a
Default Summing part of an Alpha Numeric String

A1 = 1 X
A2 = 2 X
A3 = 3 X
A4 = 6

Is there some sum left formula that will allow me to total the numbers in
cells A1:A3 and omit the text to the right?

Thank you,
Arturo