Let's say you have a number 64934 in a cell A1. Now, the challenge before you is to work out the following SUM through a formula which should be flexible enough to capture any number of digits (Don't limit this to 15 digits maximum as allowed by Excel precision but to any number of digits as numbers can be entered in text also bypassing 15 digits limit of Excel)
= First Digit x Second Digit + Second Digit x Third Digit +………..+Last Digit x 0 (Last digit wouldn't be multiplied by something else as there is no succeeding digit)
The samples cases are given below for better clarity
Note – You may choose to post the response in comments section.