Symbols in Excel.
Symbols in Excel.
(OP)
Gentlemen:
I hope someone can help me in writting symbols in Excel.
See attachment.
Regards.
I hope someone can help me in writting symbols in Excel.
See attachment.
Regards.
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.
Here's Why Members Love Eng-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: Symbols in Excel.
http://dailydoseofexcel.com/archives/2010/11/19/un...
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/
RE: Symbols in Excel.
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: Symbols in Excel.
Dik
RE: Symbols in Excel.
https://excel-tips.blogspot.com/2005/08/keyboard-s...
Below is an example of how you can insert your unicode symbols using VBA.
-JG
RE: Symbols in Excel.
For instance Unichar(8805) displays the >= symbol.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Symbols in Excel.
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))
RE: Symbols in Excel.
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/
RE: Symbols in Excel.
I really need to thank ALL of you for your assistance on this matter.
Your comments have been very helpful.
Thanks again.
RE: Symbols in Excel.
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".
RE: Symbols in Excel.
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.
RE: Symbols in Excel.
Norm
RE: Symbols in Excel.
That's OK as far as it goes, but it does not go very far. It only gets you a tiny subset of the available symbols/characters. 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 . 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.
RE: Symbols in Excel.
RE: Symbols in Excel.
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
RE: Symbols in Excel.
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/345543/what-is-the...
RE: Symbols in Excel.
looking for perpendicular symbol if anyone knows offhand....
RE: Symbols in Excel.
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.
⊥
RE: Symbols in Excel.
I also tried changing font to a few randomly selected ones from the gigantic font list. This made no difference (apart from the expected changes when using Symbol, WingDings etc).
RE: Symbols in Excel.
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/...
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
RE: Symbols in Excel.
RE: Symbols in Excel.
Thanks!
RE: Symbols in Excel.
Norm
RE: Symbols in Excel.
https://newtonexcelbach.wordpress.com/2017/06/08/t...
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/