i used to have a program called "splitty" (this wa sbefore the winrar era) that split files of any size up into 1.44MB pieces (floppy disk size). you put the utility on one of the discs and it put all the pieces back together on the other side. i thought it was pretty nifty on my old packard bell machine with 8MB ram and 33 mHz processor hah.
Reminiscing aside, the answers you get depends in large part on the purpose for why you want to do this:
you could user winrar to create .rar files of any size then as long as you have winrar installed on the source, you can just put them back together at a later time.
are you talking long term storage on cd or are you just moving them somewhere? if you're just moving the files, I'd look into an external hard drive (can never have too many hard drives ) or some high volume temporary online storage. there are programs that can convert your gmail accounts into a storage space (about 2GB). if you're just moving files you can upload them a few chunks at a time.
if you're trying to create installation discs you won't be able to install from the CDs. you'd have to put the files back together then install from a hard drive somewhere.
if you're trying to create movies and don't have a dvd burner you may want to look into VCD creation, otherwise your movies won't play off of a CD.
hope some of that helps. maybe we can be of more assistance if you ahve any other specific questions...