you must set the cells to wrap. format/cells/alignment check the wrap text box and why are you using char(13) it should be char(10)