Conor, when you are accessing the characters from the Character Map are you:
1. clicking on the Select button
2. then clicking on the Copy button
3. then going to Excel and clicking on the Paste button?
I just tried copying some characters and it worked okay for me.
It should work if you change the font to "Symbol" for the characters copied.
Nope, I've just tried exactly that procedure again and all I get is a lowercase 'l'.
I'm in Font: Symbol, click on 'lamda', click Select, Click Copy, into Excel then Paste. No Joy!
In fact, experimenting with other Greek characters and I just get the English equivalents!
What am I doing wrong?
Thanks for your swift replies on these issues.
When you select your symbol in the Character map you'll notice in the lower righthand corner the keystroke for that symbol. An example is the copyright symbol which equals ALT+0211. First format your cell(s) as symbol, then use the keystroke, making sure to use the numberpad. Hold down the ALT key while pressing then numbers then release it.
Another option is to select the text/letter in the formula bar, then change the font for just that text/letter. For example: lowercase p equals PI, so if you typed a string of text that needs to include the PI symbol, just type "p", then go back and select it in the formula bar and change the font to symbol.
Thanks very much, typing in English character then changing to 'Symbol' font did the trick.
Alas, there is no shortcut indicated for the greek characters.