2 Replies Latest reply on May 11, 2009 9:51 AM by pittsburgh.joe

    Problem Exporting Merged Fields to Excel

    pittsburgh.joe

      Title

      Problem Exporting Merged Fields to Excel

      Post

      I am trying to export First Name and Last Name fields to Excel. In my layout in Filemaker 10 using merged fields they show up fine combined. In Excel I can't get them to combine into one column. What am I missing? Need special formatting? or sliding? Thanks for the help.

        • 1. Re: Problem Exporting Merged Fields to Excel
          KIDO
            

          Merge fields are for text display purpose in FM, they don't work the same way as in Office applications. If you need to export those fields together you need to  create a new field Full Name and in Auto-Enter Calculated Value write the following expression:

                           YourTable::First Name & " " & YourTable::Last Name

           

          Change your layout to use this field (not merged) instead.  Export now as expected.

           

          • 2. Re: Problem Exporting Merged Fields to Excel
            pittsburgh.joe
               Thanks for the help! While waiting for an answer I explored Calculated fields and used =First Name & " " & Last Name as you recommended. I didn't use the Your Table portion however. I presume this is only necessary if you have multiple tables. Thanks again for your reinforcement.