How do I add multiple data lines in one cell

[Sunshine599]

I'm trying to add a list of 3-5 line items in one cell without wrapping.
For example,
In cell B2, items to list are Model 1234, Model 4a24, Model 436s, Model12d

 

[Nick Hodge]

If you mean to 'join' the data then you could use a formula like

=A1&", "&B1&", "&C1&", "&D1

etc.....

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
www.nickhodge.co.uk