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.
