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

Question

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.

TrowaD · Answer

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

Whylucky · Answer

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

Is there a way to call out multiple values in single cell?

2 responses

Similar discussions

Subscribe To Our Newsletter!