You could always just run through the text using the "instr()" function checking where the next vbCRLF came. Every time you find one, reset the current "start position" to just after it, take that text (by using left() and right() with the position of the new vbCRLF and the position of the last one to get just that text), and insert it into a ListBox using AddItem(). Of course, that isn't as simple as finding some builtin function, but as long as you can get the text from the original source, it oughta work. This is providing all the text you want comes from one cell/source/whatever. If you are talking about taking from different cells, well, I know nothing about Excel code.
Jek