I'm sorry... I the part where you said "distributed vertically in unused
cells" didn't register with me when I first read your message. Where is your
multi-line data located... in a column, in a row, or scattered about? Are
the "unused cells" you mentioned already located immediately under the cells
with the multiple lines or are they in a different place?

--
Rick (MVP - Excel)


"James R" wrote in message
...
Thanks for your help, Rick. I appreciate it. Now, what would be the
fastest
way to get that information from rows to columns? I've done the
'transpose'
function of Paste Special, is there an easier way to do it?

"Rick Rothstein" wrote:

Select the cell or cells, click Data/Text To Columns form Excel's menu
bar,
choose the Delimited option on the first dialog page, click the Next
button,
uncheck everything except Other and type Ctrl+J into the field next to it
(you won't see anything in that box, but the column layout chart will
show
that it is being split at the line feeds (they are not carriage
returns)...
then just click the Finish button.

--
Rick (MVP - Excel)


"James R" <James wrote in message
...
I am trying to improve a spreadsheet a colleague started. There are a
ton
of
carriage returns within cells.

1. How can I get rid of the carriage returns?
and
2. Is there some way I can get rid of the carriage returns, but have
the
existing text in the cell distributed vertically in unused cells?

Thanks in advance for the help, I can provide more detail if it is
needed.