MS Excel Rupee Symbol Not Displaying as a different symbol

Hello Friends,

I have a sheet with multiple instances of “ in various text strings. [No designs inside that rectangle box in actual sheet. While copying that rectangle and pasting here, its coming like that. Its just a box, which comes in replacement of Rupee symbol in all other systems ms-excel than the system where the ooriginal created ]

I want to find and replace all instances of “ only with the font 'Rupee Forandian' - ₹ in the excel sheet.

When I try the excel replace function (CRTL+H) with the format function, it changes the font of the entire text string, while I want it to change only the character `
Went thru VB Code method and used the below code :

Sub InsertRupeeForandianSymbol()
Dim X As Long, Cell As Range
For Each Cell In Selection
For X = 1 To Len(Cell.Value)
If Mid(Cell.Value, X, 1) = "“" Then Cell.Characters(X, 1).Font.Name = "Rupee Foradian"
Next
Next
End Sub

But when i copy that small rectangle box, "?" symbol is displaying in vb code window. So it also doesn't work.

Its just a text string and not a formula in the excel sheet . Excel Version is 2010.

Try to change the settings in Regional - keyboard - indian keyboard and all. But still it doesn't work.

Request your help on this. Thanks much. Please revert.

Regards.
Perpectuals

Friends, Its a very small rectangle box instances . online error is showing while adding attachments.