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.
Bookmarks