I have two cells with values in each, i want to total the values of the
two cells, but the first character in the cell is an alpha character.
Is there a way of getting the sum of the two cells? Thanks for the
help...


--
afntex
------------------------------------------------------------------------
afntex's Profile: http://www.excelforum.com/member.php...o&userid=32408
View this thread: http://www.excelforum.com/showthread...hreadid=521744

Not quite sure what you want, but here's a guess

A1: A010
B1: L001
C1: =SUMPRODUCT(--MID(A1:B1,2,255))

In that instance, the formula returns 11

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=521744

Say you have Z100 in A1 and Q35 in A2 then in A3 enter:

=RIGHT(A1,LEN(A1)-1)+RIGHT(A2,LEN(A2)-1) to display 135
--
Gary's Student


"afntex" wrote:


I have two cells with values in each, i want to total the values of the
two cells, but the first character in the cell is an alpha character.
Is there a way of getting the sum of the two cells? Thanks for the
help...


--
afntex
------------------------------------------------------------------------
afntex's Profile: http://www.excelforum.com/member.php...o&userid=32408
View this thread: http://www.excelforum.com/showthread...hreadid=521744