Exporting return separated list

[Sholly]

I am trying to export a field that is a return separated list. It is a list of all chimpanzees who are together in a group at a given time. One particular record might look like this in Filemaker:

BAR

JOL

LIL

BT

BS

When I export it to Excel it looks like this:

BARJOLLILBTBS

But I need it to look like this when it gets to Excel:

BAR JOL LIL BT BS

Is there a way to do this?

[Raybaudi]

Hi

export a calculated field:

Substitute ( list of all chimpanzees ; ¶ ; " " )

[Sholly]

Sweet! Thanks a million.