Formula Help

  • Thread starter Thread starter afntex
  • Start date Start date
A

afntex

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
 
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
 
Back
Top