Exporting to Excel - boxes around chr() arrows

[Mark4]

Using a chr() unicode function I get arrows displayed:

=if([Hist Asmt is Current]= '1', IF([Hist Asmt Progress] = 'Steady Performance', [Hist Asmt Rating] & ' ' & chr(9654),IF([Hist Asmt Progress] = 'Negative Performance', [Hist Asmt Rating] & ' ' & chr(9660),IF([Hist Asmt Progress] = 'Positive Performance', [Hist Asmt Rating] & ' ' & chr(9650)))))

When I export data and view in excel, the left and right arrows are in boxes:

I want the arrows, but I don't want the boxes. Has anyone seen this before?

[Anil_Babu_Samineni]

Because, Excel will read for Chr() as boxes around. So, Solution may be Macro to remove the boxes after exporting into Excel.

[Vegar]

A  work around could  be to switch from black to white. I think these will work better.

=if([Hist Asmt is Current]= '1', IF([Hist Asmt Progress] = 'Steady Performance', [Hist Asmt Rating] & ' ' & chr(9655),IF([Hist Asmt Progress] = 'Negative Performance', [Hist Asmt Rating] & ' ' & chr(9661),IF([Hist Asmt Progress] = 'Positive Performance', [Hist Asmt Rating] & ' ' & chr(9651)))))

[Mark4]

Thanks @Vegar , this worked great!

[Mark4 · Accepted solution]

@Vegar  My client didnt like the hollow arrows, we have a lot of apps with the solid arrows so they wanted to be consistent.  I ended up using the following:

=If([Hist Asmt is Current]= '1',
IF([Hist Asmt Progress] = 'Steady Performance', [Hist Asmt Rating] & ' ' & chr(9658),
IF([Hist Asmt Progress] = 'Negative Performance', [Hist Asmt Rating] & ' ' & chr(9660),
IF([Hist Asmt Progress] = 'Positive Performance', [Hist Asmt Rating] & ' ' & chr(9650)))))

Had to monkey around with it but it was delivered, thank you for the guidance!