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

Report
Posts
2
Registration date
Tuesday September 24, 2013
Status
Member
Last seen
September 26, 2013
-
Posts
2
Registration date
Tuesday September 24, 2013
Status
Member
Last seen
September 26, 2013
-
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.

2 replies

Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
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
1
Thank you

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

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Tuesday September 24, 2013
Status
Member
Last seen
September 26, 2013

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