See https://www.extendoffice.com/documents/excel/1697-excel-split-word-into-letters.html
Wednesday, December 30, 2020
Excel: Split Word Into Separate Cells In Excel
Wednesday, December 9, 2020
Renaming filenames, remove leading characters
This superuse post describes how a set of forward slashes (/
) can be used to delete leading characters (except .
) from a file name. One slash is required for each character to be deleted. I've confirmed the behavior on a Windows 10 machine.
ren "abc-*.txt" "////*.txt"
abc-123.txt --> 123.txt
abc-HelloWorld.txt --> HelloWorld.txt
ren "????*.*" "////*.*"
Friday, November 27, 2020
VBA Excel to Double Click change to checkmark or x
Note that to do this, you need to set the font of the affected cells to Winding 2 first:
1 2 3 4 5 6 7 8 9 10 11 12 | Private Sub Worksheet_BeforeDoubleClick( ByVal Target As Range, Cancel As Boolean ) If Not Intersect(Target, Range( "B1:B10" )) Is Nothing Then Application.EnableEvents = False If ActiveCell.Value = ChrW(79) Then ActiveCell.ClearContents ActiveCell.Value = ChrW(80) Else ActiveCell.Value = ChrW(79) End If Cancel = True End If Application.EnableEvents = True End Sub |
Monday, November 23, 2020
Solidworks Superscript or Subscript in Dimension Text
In a regular annotation note, create a stack that looks the way you like. It will take a couple of trial and error attempts since there's no preview. Once you have the look you seek, RMB on the note (without double-clicking) and then choose Edit Text in Window. Copy the raw entry from <STACK> to </STACK> and cancel. Edit your dimension and paste this into the Dimension Text edit field.
Example: <STACK size=0.6 divider=no>a<OVER></STACK>
Friday, November 13, 2020
Alt Codes for Checkmarks
Symbol | ALT Code | ALT X Code | Symbol Name | HTML Entity DEC | HTML Entity HEX | HTML Entity Named | Unicode Code Point |
---|---|---|---|---|---|---|---|
☐ | ALT 9744 | 2610 ALT X | Ballot box, check box, tick box | ☐ | ☐ | U+2610 | |
ALT 9745 | 2611 ALT X | Ballot box with check | ☑ | ☑ | U+2611 | ||
☒ | ALT 9746 | 2612 ALT X | Ballot box with X | ☒ | ☒ | U+2612 | |
ALT 9989 | 2705 ALT X | White heavy check mark | ✅ | ✅ | U+2705 | ||
✓ | ALT 10003 | 2713 ALT X | Check mark | ✓ | ✓ | ✓ | U+2713 |
ALT 10004 | 2714 ALT X | Heavy check mark | ✔ | ✔ | U+2714 | ||
✗ | ALT 10007 | 2717 ALT X | Ballot X | ✗ | ✗ | ✗ | U+2717 |
✘ | ALT 10008 | 2718 ALT X | Heavy ballot X | ✘ | ✘ | U+2718 | |
ALT 10060 | 274C ALT X | Cross mark | ❌ | ❌ | U+274C | ||
ALT 10062 | 274E ALT X | Negative squared cross mark | ❎ | ❎ | U+274E | ||
❖ | ALT 10070 | 2756 ALT X | Black diamond minus white X | ❖ | ❖ | U+2756 | |
⮽ | ALT 11197 | 2BBD ALT X | Ballot box with light X | ⮽ | ⮽ | U+2BBD | |
⮾ | ALT 11198 | 2BBE ALT X | Circled X | ⮾ | ⮾ | U+2BBE | |
⮿ | ALT 11199 | 2BBF ALT X | Circled bold X | ⮿ | ⮿ | U+2BBF | |
ALT 128499 | 1F5F3 ALT X | Ballot box with ballot, vote | 🗳 | 🗳 | U+1F5F3 | ||
🗴 | ALT 128500 | 1F5F4 ALT X | Ballot script X, X mark | 🗴 | 🗴 | U+1F5F4 | |
🗵 | ALT 128501 | 1F5F5 ALT X | Ballot box with script X | 🗵 | 🗵 | U+1F5F5 | |
🗶 | ALT 128502 | 1F5F6 ALT X | Ballot bold script X | 🗶 | 🗶 | U+1F5F6 | |
🗷 | ALT 128503 | 1F5F7 ALT X | Ballot box with bold script X | 🗷 | 🗷 | U+1F5F7 | |
🗸 | ALT 128504 | 1F5F8 ALT X | Light check mark | 🗸 | 🗸 | U+1F5F8 | |
🗹 | ALT 128505 | 1F5F9 ALT X | Ballot box with bold check | 🗹 | 🗹 | U+1F5F9 |
JSP - Java Description
https://docs.oracle.com/javaee/5/tutorial/doc/bnair.html Install Java on the computer: https://phoenixnap.com/kb/install-java-windows Insta...
-
In a regular annotation note, create a stack that looks the way you like. It will take a couple of trial and error attempts since there'...
-
I just finished a 1 hour marketing meeting with an organization that I volunteer with. They are trying to create an new website and the look...