You could use a formula like
=TEXT(B4,"MM/DD/YYYY")&CHAR(10)&TEXT(B4,"HH:MM")
in another cell. You have to format the cell to allow text wrapping, or the
line feed character appears as a little square box. Then hide your original
cells, or copy & paste the wrapped cells as values over the original cells.

Hope this helps,

Hutch

"Alex" wrote:

I have cells in the format of date and time with 2 spaces between the date
and time. I want to wrap them so that the date is on top, and time on
bottom, but they will not wrap. The only thing I can do is individually
enter "alt+enter" for each cell. Any suggestions?