Calculate the sum in cells if there are several values ​​in each cell?

Question

excel

Good afternoon! Please tell me how to calculate the sum in cells with several values ​​inside, like: 1000+500+3000000. There are many such cells. Manually for a very long time.

Answer 1

In Google Spreadsheets, this can be solved like this:
=СУММ(SPLIT(A1;"+"))
It is possible that Office 365 has the same features.
Alternatively, use a custom function. For Excel/VBA this will be a wrapper around Application.Evaluate()