Sakthikumar Chinnasamy
Member
Is there any formula to sum the numbers from first digit to last digit. Eg. if cell "A1" contain "1 to 10", then i need to sum the value from 1 to 10 and output to be display as 55. Also, i want to find the average of the same,