I want to assign comma seperated data in one cell to various selected
cells on my worksheet. Is there a formula for this? In cell A1 I have
1,2,3,4. When I paste these values into A1 I want 1 to populated in B1,
2 in B2 and so on


A B
1,2,3,4

John 1
Bob 2
Steve 3
Dave 4

Please help?


--
guyvanzyl
------------------------------------------------------------------------
guyvanzyl's Profile: http://www.excelforum.com/member.php...o&userid=35927
View this thread: http://www.excelforum.com/showthread...hreadid=557265