Thread: text combined with values
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default text combined with values
Try
=SUMPRODUCT(--SUBSTITUTE(A1:A2,"s",))

--
Jacob (MVP - Excel)


"gloucester county" wrote:

In cell A1 I typed s1.5 in cell A2 I typed s2 how do I add the values to
equal s3.5?
Reply With QuoteReply With Quote