Hi

Perhaps the following might work, depending upon how the words and text
are arranged. Without seeing the data, I can't tell (you cannot post
attachments to these NG's)

Copy the column of data to another part of the sheet, with blank columns
to the right of it.
DataText to columns to split the words and numerics.
Apply the percentage update to the values (as described)
in another cell, concatenate back the words and uplifted values.
Copy the range of the new concatenated data Paste SpecialValues back
over your original column of data.

--
Regards

Roger Govier


"tljeffrey21"
wrote in message
...

Cheers Roger, exactly what I was looking for. Any idea on how to do it
with text in the cell as well (as in the cell I want to update)?


--
tljeffrey21
------------------------------------------------------------------------
tljeffrey21's Profile:
http://www.excelforum.com/member.php...o&userid=30262
View this thread:
http://www.excelforum.com/showthread...hreadid=499290