"Latin small letter x with macron" in Excel

[Opinicus]

{Excel 2002. All updates in place.)

How do I enter a "Latin small letter x with macron"? (A small x with a bar
over it.) From Insert > Symbol it seems I can enter letters with macrons for
just about every character *except* x.

 

[Zone]

Can't find it either. Weird! It seems it's being intentionally skipped.
Maybe there is a special font available that has it. Otherwise, I can't
think of a solution other than drawing in the bar with the drawing toolbar.

 

[Michael Bednarek]

{Excel 2002. All updates in place.)

How do I enter a "Latin small letter x with macron"? (A small x with a bar
over it.) From Insert > Symbol it seems I can enter letters with macrons for
just about every character *except* x.

As the macron normally denotes a long vowel, there is no such glyph in
Unicode. However, there are combining diacritical marks in Unicode, and
the macron is x0304.

Steps:
Run Charmap; select font Lucida Sans Unicode; Go to Unicode: 0304;
press Select, Copy.

Run Notepad; type xCtrl+v. (That is the letter x followed by Ctrl+v)
This will create an x+macron.
Ctrl+a Ctrl+c will Select All and Copy.

Run Excel; in a cell, Ctrl+1 and select Font Lucida Sans Unicode;
Ctrl+v - voilà.

There might be simpler methods, e.g. with Unicode Input from
<http://www.fileformat.info/tool/unicodeinput/index.htm> or other such
programs, or finding a font which has such a character built-in,
possibly in a Reference or Mathematica font (although I haven't found
it).

 

[Dave Peterson]

Maybe this tip from Debra Dalgleish will help:
http://contextures.com/xlfaqFun.html#bar

 

[Ron Rosenfeld]

{Excel 2002. All updates in place.)

How do I enter a "Latin small letter x with macron"? (A small x with a bar
over it.) From Insert > Symbol it seems I can enter letters with macrons for
just about every character *except* x.

You can enter it either as a custom font character, or as an object.

There is the Private Character Editor supplied with Windows.
You can create custom characters with it and make them part
of one or more fonts.
In "Run" enter: eudcedit.exe
You will have to read the help file.

OR

You can use Microsoft's Equation Editor;

From the main menu bar:
Insert/Object
Create New
Microsoft Equation 3.0

Then type <x> <ctrl-shift-hyphen>

You may want to format the object as <no line> when you get back to the main
worksheet.
--ron

 

[Opinicus]

You can use Microsoft's Equation Editor;

From the main menu bar:
Insert/Object
Create New
Microsoft Equation 3.0
Then type <x> <ctrl-shift-hyphen>
You may want to format the object as <no line> when you get back to the
main
worksheet.

That's exactly what I wanted. Thanks!

 

[Ron Rosenfeld]

That's exactly what I wanted. Thanks!

You're welcome. Glad to help.
--ron