i want to enter the number in the first cell of output, so using your
terminology, x1=a1. this creates a circular reference using left so
that wont work. i might have to use your way. in any case, your reply
is a big help. any additional help is appreciated.


--
lsu-i-like
------------------------------------------------------------------------
lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317
View this thread: http://www.excelforum.com/showthread...hreadid=379487