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

Whylucky 2 Posts Tuesday September 24, 2013Registration date September 26, 2013 Last seen - Sep 24, 2013 at 12:28 PM - Latest reply: Whylucky 2 Posts Tuesday September 24, 2013Registration date September 26, 2013 Last seen
- 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
TrowaD 2438 Posts Sunday September 12, 2010Registration dateContributorStatus October 18, 2018 Last seen - Sep 26, 2013 at 11:32 AM
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

Thank you, TrowaD 1

Something to say? Add comment

CCM has helped 1257 users this month

Whylucky 2 Posts Tuesday September 24, 2013Registration date September 26, 2013 Last seen - Sep 26, 2013 at 11:36 AM
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