excel is substituting unicode for a defined name of a cell
 

I am having a problem in excel that is baffling me.

I have 2 worksheets that are linked with defined names. I am pulling the
text from the defined name of wks 1 to a cell in wks 2.
The cell in wks 2 should display the text Class A instead I get a cell full
of Unicode characters. I have checked the formating and font of both the
linked cells and made sure the defined names are correct. The text looks like
this.

瀀祰献污ç�¥çŒ®ç‰¨áµ³ 义䕔䕒呓ä¤*ä�Žäµ��…䕄䕆剒ä±�´*ä°*á±” 义䕔䕒呓ä¤*ä�Žäµ��…€*ä¡“å‰��”䕔䵒 䤀呎剅å�…�”义佃ä•�ä�*䙅剅䅒�Œ€*å‘“ 䤀瑮牥ç�¥�´ç¡…æ•°ç�®áµ¥
ä¤*ä�Žäµ��…ä¹�å€*å¥�佄乗äœ*ä¥�½Žä½Œå�“à¤* 㔱㔹弰〰र 㜲〰弰〲ର å�†�„ä•’½ƒä…�á*™ 义佃ä•�´*å€*ä��å€*å¥�佄乗ä°*å��䕓᱓
䅃䱌ä„*ä�ƒå•�å‘Žä¤*呎剅å�…�”义佃ä•�$ä¤€å‘Žå ‰…å�…�”ä…”�˜ä¥—䡔䕈䑌´*äŒ*ä±��Œä��佃乕 Shares

The shares part of the text is hard coded. All the rest should be Class A.

Any help would be appreciated.
Thanks
Mack