why xlswrite has @ character?

Hi all,

I used xlswrite to write string function to excel cell.

Such as:

xlswrite('resultFile.xlsx', {['=FREQUENCY(A1:A1000,C1:C30)']},'Sheet1', 'D1')

But result in excel file contains '@' character like this.

How to fix it?

Thank you

Answer 1

[Monika Jaskolka]

This is something that happens automatically in Excel. Please see:

• https://www.mrexcel.com/board/threads/ampersands-appearing-in-formulas.1113077/
• https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34?ui=en-us&rs=en-us&ad=us

[galaxy]

Thank you so much