I put together a little sample file that demonstrates this.

Send me an email:

xl can help at comcast period net

Remove "can" and change the obvious.

This requires an array formula and you can't enter array formulas in merged
cells. Merged cells really don't do anything but cause problems!

Biff

"fastballfreddy"
<fastballfreddy.27ml3a_1147321202.2769@excelforu m-nospam.com wrote in
message news:fastballfreddy.27ml3a_1147321202.2769@excelfo rum-nospam.com...

Ok, I can undo the merged cells, but what would I use for a formula?
Let's just say the names are in A1-A10, the #s in B1-B10. What formula
would you use in C1?

thanks


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile:
http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=540574