Overstrike two characters in Excel

[Warren Bittner]

Is it possible to overstrike two characters in Excel to create a new
character? I need the letter n with a straight bar above it. "n¯" I can do
this in Word, but not Excel.
Thank you.

 

[Bob Greenblatt]

On 2/1/07 9:49 PM, in article
(e-mail address removed), "Warren Bittner" <Warren

Is it possible to overstrike two characters in Excel to create a new
character? I need the letter n with a straight bar above it. "n¯" I can do
this in Word, but not Excel.
Thank you.

I can't figure out how to do it.

 

[JE McGimpsey]

Is it possible to overstrike two characters in Excel to create a new
character? I need the letter n with a straight bar above it. "n¯" I can do
this in Word, but not Excel.

XL doesn't have the display engine to do this. There *are* fonts
available that include the "n with macron" that you could then insert
into XL via the system Character Palette. No, I don't know which ones,
but I've seen them.

A poor alternative would be to capture the character, perhaps in Word,
as a pic and overlay the pic onto the cell where you want the character
to appear.

 

[CyberTaz]

I was looking along the same lines, John, & couldn't find an "n with micron"
or "n with overbar" even in Lucida Grande or MS Gothic - perhaps in some
sort of specialty category of font?

Warren - is this some sort of "discipline-specific" symbol or just something
you would like to do for other reasons?

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[JE McGimpsey]

I was looking along the same lines, John, & couldn't find an "n with micron"
or "n with overbar" even in Lucida Grande or MS Gothic - perhaps in some
sort of specialty category of font?

No, it's not in any of the standard fonts delivered with MacOSX or
Office. But I have seen references to specialty fonts that include the n
with macron (not micron).

 

[Warren Bittner]

Bob,
I guess you could call this discipline-specific. I am writing instructions
on transcribing nineteenth-century German church books. The n with a bar
above it is a common abreviation for nn. For some unknown reason, the
template I have been asked to write into is in Excel, not Word.
Thank you.
Warren

 

[CyberTaz]

Thanks for posting back - in this case I would say the character is
"language-specific"... And unfortunately a rather uncommonly used one
perhaps. As John wrote, I doubt you'll find it in any of the readily
available fonts. If you truly need it you might try googling for it.

Good Luck |:>)
Bob Jones
[MVP] Office:Mac

 

[Joe Stoffa]

I am running into this problem as well. Lowercase n with a macron is used for
some mathematical variables. My eventual solution was to change the Excel
zoom to 400%, and draw a 0.50 wt. bar over the n using the drawing toolbar.
It worked in my case as I simply wanted the symbol to look correct upon
printing -- but I have no need to move/copy/paste this symbol now that it is
in place.

 

[jpdphd]

You can also use Equation Editor to get letters with bars over them
(or hats, tildes etc). The downside is that the result is an object
that must be placed tediously within the text (and the text must have
a suitable space to display the object without running into it).
If you have Equation Editor installed, do
Insert > Object... > Equation Editor equation

If EE wasn't installed, go back to your installation disk and you
should be able to install it without reinstalling all of Office.
jpdphd