You can replace all "" with 0 (zeroes) and all & with +.
This will keep the formula as it is (I mean without enclosing it in
VALUE function).

I'm just not sure if this solution meets all possible outcomes you may
encounter. Check it out :)


--
nCage
------------------------------------------------------------------------
nCage's Profile: http://www.excelforum.com/member.php...o&userid=29605
View this thread: http://www.excelforum.com/showthread...hreadid=493025