Thread: How do I add multiple data lines in one cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge Nick Hodge is offline
external usenet poster
  
Posts: 1,173
Default 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

Reply With QuoteReply With Quote