You will need "empty" cells to the left or right of the column you want
to split or they will be overwritten when you split, (i.e. if you split
1 column into 3 - you need 3 empty cells.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=520063