i know how to create a graph with formulas at the bottem to calculate totals, but is there a way to turn the numbers in to text and it still adds up a total i.e 4 x car text in a coloum and then the total will come out as number 4
If I have understood you correctly, I suggest you investigate the use of string manipulation e.g. Assume you type “5 bikes” in cell A1. In cell B1 type “=VALUE(LEFT(A1,1))” without the inverted commas. The number 5 will appear in cell B1.
LEFT(A1,1) extracts the first character in the string in A1 (i.e. the part that looks like the number 5). VALUE, then takes that string, and turns it into the number 5.
The problem is this will only work for number between 0 and 9.
If you do LEFT(A1,2), you get the first two characters, but if you then put in a string “5bikes”, you get “5b” which will generate an error. “5 bikes” is OK, because of the space between 5 and bikes.
If you are careful with just how you enter the strings, this simple approach may work.