I have a spreadsheet which contains data in cells.
The data begins with an alpha character, i am wanting to know if
someone could help with a formula that would start with the second
character, which is a number and total the cells.

Example:

a1 = K12500050
a2 = K12500300
a3 = total of a1, a2

Thanks


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

Entered as an array formula (shift ctrl Enter at the same time)
something like the following should work
=SUM(MID(a1:a2,2,99)*1)

I am assuming none of your numbers is more than 99 characters long!

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=526641