Is there a way to call out multiple values in single cell? [Solved/Closed]

Posts
2
Registration date
Tuesday September 24, 2013
Last seen
September 26, 2013
- - Latest reply: Whylucky
Posts
2
Registration date
Tuesday September 24, 2013
Last seen
September 26, 2013
- Sep 26, 2013 at 11:36 AM
Hello everyone, this is tricky and im not sure if i have missed something or if this is even possible, if it is it would be a huge help. I am limited in my space to the right of the document so making a single cell with 4 or 5 values would be helpful. Is there a way i can call each of these values separately to run in my calculations? For example if the cell says "Water,horse,6,20" it will be able to know where each of those values go and calculate them? Thank you in advance.
See more 

2 replies

Best answer
Posts
2440
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 13, 2018
1
Thank you
Hi Whylucky,

Here are some suggestions:

1) Adding extra columns doesn't have to increase the size of your document.

2) You could extract values using the functions Left, Mid, Right.

3) Why don't you also place those values outside your document or even on a different sheet.

Best regards,
Trowa

Say "Thank you" 1

A few words of thanks would be greatly appreciated. Add comment

CCM has helped 2902 users this month

Posts
2
Registration date
Tuesday September 24, 2013
Last seen
September 26, 2013
0
Thank you
thats what i ended u p doing, using the left and right from commas and such to select values then calling them into a separate space to do the calculation, then returning the answering to my specific cell, thanks for the advice