Hi there,

I have a values + or - in one column and the number in the next

What I want to do is add the + or - to the number i.e.

- in one column, 10 in the next you get -10

I know I can do this by using the & function but this is not the way I want
to do it

I don't want it to lookup, I would like it to be permament, and it must
totally replace the value 10 with -10 as in the above example

I hope this is not clear as mud, Hope someone can help

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1