View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Replacing characters in numeric text strings and SUMming

Or, as an alternative,
=VALUE(A1)+VALUE(A2)