AnsweredAssumed Answered

Newbie Needs Help - Exporting Value Lists to Excel

Question asked by NatalieKelly on Apr 19, 2011
Latest reply on Apr 19, 2011 by LaRetta_1

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.

Outcomes