I have cell A1 which is a text string:
100 blue cars, 100 red cars, 100 yellow cars
In cell B1 I have a number which is a multiplier say 2
.
Is it possible to change the numbers within cell A1 dependant on the value in B1.
Eg.
A1: 300 blue cars, 300 red cars, 300 yellow cars
B1: 3