![]() The UDF will only work from Excel files with the UCode VBA code, and a range named UCList.Īny questions or comments, please let me know. Once the auto-correct macro has been run it will work from any Excel file, or any other MS Office application. For the UDF the ASCII strings should not be enclosed in (). An example of the UDF UCode, that will replace the ASCII strings from the UCList list with the equivalent Unicode values. Extend the range name "UCList" if necessary. 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. A list of mathematical symbols and Greek characters, with the associated Unicode decimal value. For any value > 16 it will return a range of 512 characters, starting with the code entered in A2 (treated as a Hex value) 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. A table of Unicode characters for a range of codes. I have also written a UDF to convert ASCII strings to Unicode characters. ![]() This section is dedicated to tools every electrical engineer can use in daily work. ![]() Updating the autocorrect list converts this feature from something that is just annoying into something really useful.Īdding a lot of characters is pretty tedious though, so I have written a macro to do it from a list on the spreadsheet. 10 Electrical MS Excel Spreadsheets for Electrical Engineers.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |