Extracting comma seperated data from in one cell so that it will
populate in another? The data may be various lengths or be empty.

eg: 123,,2345,67894,1,,3

The file I am currently working with has 23 fields each of them varying
lengths (and they may not be populated to their max or are not populated
at all). Is there a formula I could use in the destination cells to
extract the required piece of data.

I have tried some formulas (MID), however they only seem to only work
for fixed lengths.

i'm really struggling to crack this one despite some helpful guidance.


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