On Sat, 6 Feb 2010 23:18:01 -0800, bluenote31
wrote:

Hi!

I tried a search first and couldn't find anything like this. My spreadsheet
has a column for shipping that takes a series like this for each product:

?0.0*0.13.2*d*0x0x0:07:24:04

Following the question mark is the handling charge (0.0 in this example).
This is followed by an * and then the weight of the item (0.13.2 in this
example which is 13.2 ounces)

I have a list of product weights in a colum with just pounds and ounces. I
need to copy that information, then paste it into the weight area of the
string above and then paste those modified contents back into the original
cell the weight was copied from.

So, if the cell contained 1.8.2 (1 LB, 8.2 OZ) then I would want to run
something that would take that and replace it with
?0.0*1.8.2*d*0x0x0:07:24:04.

I know I'm not explaining this well, I'm an excel novice :). Thank you for
any help you can provide.

~Bluenote31

You could do it with a macro, but where are the other values coming from?

In other words, where is the data that defines the handling charge and the
"*d*0x0x0:07:24:04" ?

--ron