Splitting formula Values from one cell into separate cells

[thegrandmaster]

Hey,

The problem i'm facing is that the sheet i'm working on has multiple values but i can only see the end result.

ex: the cell A1 would be containing "1+2+3" but what i get to see is the result "6" in the cell.

So my question is there any way to split the data into its component parts, ie. 1 , 2 , 3 from cell A1 into three separate cells for example?

Hope someone can help me with this issue.
Thanks in advance.

[ragulduy]

Perhaps:

1. select cells
2. press ctrl+` (next to 1)
3. use text to columns with + as the delimiter
4. use find and replace, searching for = and replacing with "" (nothing)

[thegrandmaster]

Thank You very much man. It worked.

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.