Symbols in Excel. 11

[Jano6924]

Gentlemen:

I hope someone can help me in writting symbols in Excel.
See attachment.
Regards.

 

[IDS]

A quick search didn't find much, and most of what I did find wasn't very helpful, but the link below looks like it might give you what you want, at least from VBA:

http://dailydoseofexcel.com/archives/2010/11/19/unicode-and-vbas-chrw-and-ascw-functions/

Please let us know if that helps or not.

By the way, you'll probably get more response here if you post your actual question where everyone can see it, rather than in the attachment!

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[IRstuff]

FYI, most people are not desiring to open files from unknown people on the internet.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert!

https://www.youtube.com/watch?v=BKorP55Aqvg

faq731-376 forum1529 Entire Forum list

http://www.eng-tips.com/forumlist.cfm

 

[dik]

I've done it lots of times... just change the format of the font to Symbol and you have a whole collection to choose from.

Dik

 

[JG2828]

There is no way to key in unicode symbols above 255 in excel. It just wraps around to 0 again. However, per instructions on this website, you can use custom Excel Autocorrect settings to do what you are looking for. ie type (inf) and it will autocorrect to the infinity symbol.

https://excel-tips.blogspot.com/2005/08/keyboard-shortcuts-to-insert-special.html

Below is an example of how you can insert your unicode symbols using VBA.

-JG

 

[IDS]

I have just discovered that since 2013 Excel has a Unichar function, that will return all the Unicode characters.

For instance Unichar(8805) displays the >= symbol.


Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[JG2828]

Doug,
Nice find! I didn't come across that one. UNICHAR coupled with HEX2DEC might be an option since OP's question used Hex unicode notation.
Try
=UNICHAR(HEX2DEC(2264))

 

[IDS]

JG - thanks for your post also. Updating the autocorrect list converts this feature from something that is just annoying into something really useful.

Adding a lot of characters is pretty tedious though, so I have written a macro to do it from a list on the spreadsheet. I have also written a UDF to convert ASCII strings to Unicode characters.

In the attached spreadsheet there is:

- A table of Unicode characters for a range of codes. Enter 1-16 in cell A2 and it will return the codes from the Wikipedia "Mathematical operators and symbols in Unicode" page, together with a description of the group returned. For any value > 16 it will return a range of 512 characters, starting with the code entered in A2 (treated as a Hex value)

- A list of mathematical symbols and Greek characters, with the associated Unicode decimal value. If you click the "Update Auto-correct"button it will do what it says, so for instance entering (+-) will be converted to the Unicode +- symbol. The list can be edited or extended. Extend the range name "UCList" if necessary.

- An example of the UDF UCode, that will replace the ASCII strings from the UCList list with the equivalent Unicode values. For the UDF the ASCII strings should not be enclosed in ().

Once the auto-correct macro has been run it will work from any Excel file, or any other MS Office application.

The UDF will only work from Excel files with the UCode VBA code, and a range named UCList.


Any questions or comments, please let me know.

Linked file updated 7 May 2017

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[Jano6924]

Guys:

I really need to thank ALL of you for your assistance on this matter.

Your comments have been very helpful.

Thanks again.

 

[Denial]

Doug,
Great bit of work (where I am using "great" in both the magnitude sense and the benefit sense).
Since it is inaccessible via my Excel-2010 I have not looked at it in much detail, but I happened to notice that at cell AR13 you have labelled the "is proportional to" symbol as "approx".

 

[IDS]

Denial, thanks for that.

My other self was telling me that wasn't quite right when I typed it in.

I should have listened to me.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

I have now corrected the file linked in my previous post, and also added a button to remove a list of auto-correct items.

 

[NormPeterson]

Key combinations obtained by holding down the [Alt] key and typing the appropriate number using the keypad works at least in whatever version of Excel (or Word) ended up as Office 12. For example, [Alt] + 241 returns the plus/minus sign ± . . . but you do have to have the Num Lock on.


Norm

 

[Denial]

Norm.

That's OK as far as it goes, but it does not go very far.[&nbsp;] It only gets you a tiny subset of the available symbols/characters.[&nbsp;] And (for higher numbers at least) it gives different results in Word than in Excel, where in the former 259 gets you an accented "a" while in the latter it gets you a heart .[&nbsp;] And some of the characters it does not offer include the more frequently used ones such as "<=".

I'm talking Word-2010 and Excel-2010, but I doubt the other versions are any different.

 

[zelgar]

Additionally, you might consider using Microsoft Equation Editor.

 

[NormPeterson]

And some of the characters it does not offer include the more frequently used ones such as "<=".

I can get that in my version (it's [Alt] + 243). It may have something to do with the cell's font - I normally use Arial and can use symbols via keystroke combinations without difficulty.

I assume that the Symbol font provides many or possibly most of the other symbols in common use. With an English to Greek letter chart handy, just type the whole thing in English and convert letters to symbols individually.

Norm

 

[JG2828]

Just came across an answer to OP's original question about how to key in Hexadecimal unicode symbols. However you will need to edit the registry to enable it. After changing the registry and rebooting you can hold ALT, press + on the number pad, then your 4 digit hex code (2264) and receive the correct symbol.

Open regedit.exe
Navigate to HKEY_CURRENT_USER\Control Panel\Input Method and add a string or REG_SZ value EnableHexNumpad.
Set the value to 1.
Log out and log in.
Now you can use ALT <numpad +> 2264

Found this info here:

https://superuser.com/questions/345...umber-for-the-square-root-symbol-√-in-windows

 

[Triangled]

nice thread!
looking for perpendicular symbol if anyone knows offhand....

 

[JG2828]

Perpendicular symbol is 22A5 in Hex unicode. You will have to edit the registry or use one of the other methods mentioned above to use it.

Here is a nice site that lists them all by name. There are three different perpendicular symbols.

http://ascii-table.com/unicode-index-p.php

Alternatively you could just copy and paste the symbol from that website into your excel cell.

⊥

 

[Denial]

Norm.[&nbsp;] I'm not sure whether to classify this as interesting or weird.[&nbsp;] Maybe both.[&nbsp;] When I enter [Alt]243 I get the "three-quarters" symbol.[&nbsp;] This is Arial font in Excel-2010, running under Windows-7 Professional.

I also tried changing font to a few randomly selected ones from the gigantic font list.[&nbsp;] This made no difference (apart from the expected changes when using Symbol, WingDings etc).

 

[JG2828]

Denial,
Do you have your computer set to a language/region other than US English? Windows has different "code pages" that control what the alt codes do based on the language and country/region you set.

You can run the windows built in command line tool Chcp to see which code page is active on your system.

https://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/chcp.mspx?mfr=true

This is what mine returns:
C:\Users>chcp
Active code page: 437
You can then reference that number on this wikipedia page

https://en.wikipedia.org/wiki/Windows_code_page

chcp can also be used to change the active code page.

JG