Maybe you could try copy,paste special, transpose to columns

if you need to keep the cell references you may have to do another
step
such as
highlite the range
edit,find
find =
replace with "
then copy and transpose to columns
then edit,find
find "
replace with =

your references are still intact


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539666