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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to add 3 column (of YES) to give a total % complete 7
excel formula 1
Help Creating Excel Formula 4
formula in excel 2
Excel formula, sum the value cell and if empty cell left blank 0
Creating a formula relating to several cells 2
Can conditional formatting be used where ..... 2
formula to add Alpha? 3

Back
Top