This great. Thanks for the hint. The only drawback is that I can't
copy and paste to multiple cells like other calculations.

sorry, copy and paste works. I manually entered some data before
reading the answers. The text didn't change after I pasted the
calculation so I thought it wasn't pasted over. With closer look at
each cell, I found they were replaced witht the formula. No control-
shift-enter needed.

Thanks for the helpful newsgroup!!