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

    Newbie Needs Help - Exporting Value Lists to Excel

    NatalieKelly

      Title

      Newbie Needs Help - Exporting Value Lists to Excel

      Post

      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):

      Accounting

      Finance

      Marketing

      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.