Excel - SUM Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

add or sum the value of a cell ie. value 18 1+8=9
Solved by B. B. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 28/09/2018 - 03:38
Hi
Excelchat Expert 28/09/2018 - 03:38
Welcome to excelchat
Excelchat Expert 28/09/2018 - 03:39
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows
Excelchat Expert 28/09/2018 - 03:39
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert 28/09/2018 - 03:40
Based on what you shared, I understand that if a cell contains 35, then the formula should give the result 8 (3+5)
Excelchat Expert 28/09/2018 - 03:40
Do you believe that will address your problem?
User 28/09/2018 - 03:40
YES
Excelchat Expert 28/09/2018 - 03:42
=VALUE(Left(D4,1)) + VALUE(RIGHT(D4,1))
Excelchat Expert 28/09/2018 - 03:42
This formula will help you with it
Excelchat Expert 28/09/2018 - 03:42
It assumes that the value is in D4 cell
Excelchat Expert 28/09/2018 - 03:43
Does this solution solve your problem?
User 28/09/2018 - 03:44
yes thanks, could do so in 4tran etc
Excelchat Expert 28/09/2018 - 03:45
I did not understand what you meant by 4tran
Excelchat Expert 28/09/2018 - 03:45
Could you please expliain
Excelchat Expert 28/09/2018 - 03:45
*explain
User 28/09/2018 - 03:47
fourtran math based computer language.. cobol is another
Excelchat Expert 28/09/2018 - 03:47
I am not aware of how those will work
Excelchat Expert 28/09/2018 - 03:48
Do you have any other questions about this problem and the solution?
User 28/09/2018 - 03:48
no thanks again
Excelchat Expert 28/09/2018 - 03:48
you are welcome
Excelchat Expert 28/09/2018 - 03:48
Thanks for coming to Excelchat.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.