Inputing greek symbol in concatenated text

5 pts.
Tags:
Microsoft Excel
Microsoft Excel 2003
Windows XP Professional
I am trying to concatenate the contents of several cells (which contain alpha numeric data) into a text statement and and also concatenate the Greek letter "mu" representing micro to the end of the statement. When I do this it appears as m. It seems as if I need to be able to specify a symbol font for this one character but I see no way to do this.  

Software/Hardware used:
Excel 2003 and XP Professinal

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi Henry

All letters and symbols have a numerical code assigned to them in Windows and you can use these codes to type them. For example the code for µ is 181 and the code for ¢ is 162. You must hold the alt key down and type in the number code with a preceding 0, using the keypad (not the normal number keys).

So if you press alt-0181 you will get a µ micro symbol.

Excel has a function ‘CHAR’ used to display a character from a code, and a function ‘CODE’ to do the opposite and display a code from a character.

You could use “=CHAR(181)” in your formula.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Meandyou
    "Inputing greek symbol in concatenated text" Its all Greek to me. Sorry, I couldn't resist. :-)
    5,220 pointsBadges:
    report
  • Kevin Beaver
    On a related note, many people aren't aware of the Windows Character Map that's available via Accessories/System Tools. Very useful for entering special characters into documents, Twitter, whatever.
    17,800 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following