In this case, copy the whole formula from Bob's message and paste it into the
formula bar for that cell.

(I wouldn't want to type it in from scratch!)

cjjoo wrote:

how do i insert the {} brackets? Do i have to insert them as ctr+ shift
+ enter ?

--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=486158

--

Dave Peterson