Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to enter a function in an excel sheet that converts all cells values, that are texts, to it Unicode values.

For example I want ü to be ü and so on.

How can I achieve this, is it possible?

share|improve this question
    
I'm confused. If it's already in unicode, why would you need to convert it to unicode? Some documentation here – Raystafarian Feb 10 '12 at 12:53
    
@Raystafarian: It seems that RaduM wants HTML &# entities and the website automatically "unconverted" their example. – grawity Feb 10 '12 at 14:14
    
@grawity Ah, the questions has clarified that now – Raystafarian Feb 10 '12 at 15:36

Try this

FORMULA

="&#"&CODE(A2)&";"

OUTPUT

ü

Here CELL A2 contains "ü"

share|improve this answer
    
LOL Siva, that was really easy, but I need to parse the text that contains those characters for example ülorem will convert to a number and I only need to convert ü. – RaduM May 24 '12 at 5:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .