How to - decode unicode to ascii - needs an excel function

[asafush]

Hello,

I'm trying to figure out if there is any function in excel (2007) which helps
decoding unicode to ascii?

I have one column in my sheet which contains word/sentences in Spanish and I want to create a new column which will be contained with the unicode value of each word/sentences.

For Example,

País => " País "

How do I decode (unicode to ascii) the word 'País' in excel?

Thank's for helping...

 

[pgc01]

HI

Try this udf:

Function GetUC(s As String) As String
Dim sResult As String
Dim j As Long
 
For j = 1 To Len(s)
    sResult = sResult & "/u" & Right("000" & Hex(AscW(Mid(s, j, 1))), 4)
Next j
GetUC = sResult
End Function

 

[asafush]

Something like

Function Decode(dString As String)
Dim dLen As Long, dTemp As String
    For dLen = 1 To Len(dString)
        dTemp = dTemp & "& # " & Asc(Mid(dString, dLen, 1)) & ";"
    Next
Decode = dTemp
End Function

Would create the strings you asked for, but wouldn't eliminate any invalid character problems.

Hi jasonb75,

Your posted function was very useful for me.. saved me lots of time.

However, I'm trying to figure out the vice versa function, which takes the unicode values
and do the opposite action.

Any Idea?
Thanks'.

 

[jasonb75]

Hi jasonb75,

Your posted function was very useful for me.. saved me lots of time.

However, I'm trying to figure out the vice versa function, which takes the unicode values
and do the opposite action.

Any Idea?
Thanks'.

You mean you want to take the string " & # 80;& # 97;& # 237;& # 115; " and return " País " ?

 

[asafush]

I mean, it takes:

/u0050/u0061/u00ED/u0073

and returns País...

Thank's!