Are you using the query as the Record Source of a form? If not, do that instead. Cut the Concat code from the query and paste it into the Control Source of a textbox in this form.
Are you using the query as the Record Source of a form? If not, do that instead. Cut the Concat code from the query and paste it into the Control Source of a textbox in this form.
* Create a table based on that query and remember to set the datatype to Memo. Export this to Excel
Or
* Create function to export parts of that field in chunks
Or
* Export to Word instead of Excel