I have an array field that I am displaying on my report. I'm outputting the report in excel format but I'm getting many rows for one entry. It appears if there is a return in the array field when it gets outputted to excel it will go to the next cell down when there is a return in the data. Any ideas on how I can get the entire array field outputted in one excel cell?

This message has been edited. Last edited by: <Kathryn Henning>,

Hi,
Try below code.This may not be exact solution but will give you an approach.
DEFINE FILE CAR
vbcrlf/A6 = HEXBYT(13,'A1')||HEXBYT(10,'A1');
DUMMY/A1500V=COUNTRY||vbcrlf||MODEL;
END
TABLE FILE CAR
PRINT
DUMMY AS ''
BY CAR AS ''
ON TABLE PCHOLD FORMAT EXL2K
END