=A1&char(10)&A2&char(10)&A3&char(10) ... etc.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"feliciamm" wrote in message
...
hi. i want to merge many rows in to one cell. there are many names on
companies i want to display in a flowchart and want to be able to take the
individual rows and make them one cell so i can wrap the cell and format
to
the left

-- is there a way to do that?