Posted to microsoft.public.excel.misc
|
|
extracting comma seperated from a single cell and auto populating in selected cells o
enter in B1 =MID(A1,1,1)
in B2 =MID(A1,3,1)
in B3 =MID(A1,5,1)
in B4 =MID(A1,7,1)
guyvanzyl Wrote:
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?
--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=557265
|