Thanks Ken, It worked like a charm. I thought i was going to have to
edit cell by cell, over 1500 of them. This short cut sure was easy!!
John


--
John K
------------------------------------------------------------------------
John K's Profile: http://www.excelforum.com/member.php...o&userid=34726
View this thread: http://www.excelforum.com/showthread...hreadid=544910