Inputing greek symbol in concatenated text
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
Software/Hardware used:
Excel 2003 and XP Professinal
ASKED:
January 10, 2010 2:58 AM
UPDATED:
January 14, 2010 1:45 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
“Inputing greek symbol in concatenated text”
Its all Greek to me.
Sorry, I couldn’t resist.
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.