How do I add multiple data lines in one cell
 

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

How do I add multiple data lines in one cell
 

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
DTHIS
www.nickhodge.co.uk


"Sunshine599" wrote in message
...
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