Hi,

I wouldn't start from having numbers and letters in the same cell but if you
must

=LEFT(A1,1)&MID(A1,2,LEN(A1))+MID(A2,2,LEN(A2))

Why not use a custom format for the cell of

"s"0.0

Now you can sum them using sum
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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?