Hi there,

I have a slight problem and I hope that the people at this forum can
give me a hand.

I have a database which has over 200 pages and I would need a script
which could do the following to ease my
work;

http://img233.imageshack.us/img233/4388/excel6wg.jpg

I need the script to add the value in the E column (the way I show
within the brackets). The script should ignore letters, commas points
etc, and just add up the numbers to a 2 digit value, placeing the
answer in the H column.

I would greatly appreciate if someone could lend me a helping hand with
this, since I have to add the up manually until now... Thats what I get
for not knowing excel ;)

thnx for your time,

Soul.


--
Soul
------------------------------------------------------------------------
Soul's Profile: http://www.excelforum.com/member.php...o&userid=30265
View this thread: http://www.excelforum.com/showthread...hreadid=499350