View Single Post
  #1   Report Post  
Randomerz Randomerz is offline
Junior Member
 
Posts: 2
Unhappy 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!