3 Replies Latest reply on Apr 19, 2011 4:36 PM by LaRetta_1

    Newbie Needs Help - Exporting Value Lists to Excel



      Newbie Needs Help - Exporting Value Lists to Excel


      I've set up fields as value lists so I can use check boxes to data to records rather than type in text.  This is for a staffing database.  I need to export the data to Excel so my co-workers can view it, but when I do, the values all run together.  For example, if someone has experience in Accounting, Finance, and Marketing, the data in the Excel cell displays: AccountingFinanceMarketing.  I'd like them to show up with commas between them or with a return after each (no blank line between them though, that's just the format in this format after you do a return):




      I've tried all kinds of things to get around this but I'm not an IT person and am new to FileMaker so I'd appreciate any suggestions you can give me.