Combine Cell Contents to with a [return] or [fill with spaces] between each cells contents

Hi guys and girls

Is it possible/ is there a method that would allow me to imitate the use of the Return key on a cell, such that when the macro runs it fills the space between to the edge of the cell (where the next column starts)
with spaces (or similar), thus allowing me to continue on the 'next line' of the same cell ?

I ask this because I wish to tidy the look of my reports up - currently if i use Text wrapping then Row heights become distorted

Kind Regards

Hi Jordan,

Have you found the Alt+Enter shortcut that will start a new line in the same cell. Then you could format it to the center. Will that work for you?
http://www.ddmcomputing.com/excel/keys/xlsk04.htm