Multiplying a Number Found in an Alphanumeric String
I am working on a project that someone none-too-bright started.
The cell that I need to update looks like this:
Monkeys
$233
Dogs
$159
Yes, these four line items are in one cell. How can I increase each value by 2.5%?
NOTE: The number of spaces to each value in each cell is not consistent. One cell might start with "Monkeys" and the next might start with "Apes"
Please help!
|