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
Is it possible to change the numbers within cell A1 dependant on the value in B1.
A1: 300 blue cars, 300 red cars, 300 yellow cars B1: 3