**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.*