View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wigi Wigi is offline
external usenet poster
 
Posts: 396
Default How do I export report and have info appear on 1 line?

You can use & to "glue" cell contents together in a new cell. Alternatively,
the CONCATENATE function in Excel.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Jackson" wrote:

I am trying to export a report with manny fields but I would Like to view all
categories on 1 line, how do I accomplish.