Excel: Split Word Into Separate Cells In Excel

 See https://www.extendoffice.com/documents/excel/1697-excel-split-word-into-letters.html

In a blank cell next to your data, C1 for instance, enter this formula:

     =MID($A1, COLUMNS($A$1:A$1), 1)

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 "????*.*" "////*.*"

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

This is modified from: https://www.extendoffice.com/documents/excel/3923-excel-double-click-for-check-mark.html

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>

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	&#9744	&#x2610		U+2610
	ALT 9745	2611 ALT X	Ballot box with check	&#9745	&#x2611		U+2611
☒	ALT 9746	2612 ALT X	Ballot box with X	&#9746	&#x2612		U+2612
	ALT 9989	2705 ALT X	White heavy check mark	&#9989	&#x2705		U+2705
✓	ALT 10003	2713 ALT X	Check mark	&#10003	&#x2713	✓	U+2713
	ALT 10004	2714 ALT X	Heavy check mark	&#10004	&#x2714		U+2714
✗	ALT 10007	2717 ALT X	Ballot X	&#10007	&#x2717	✗	U+2717
✘	ALT 10008	2718 ALT X	Heavy ballot X	&#10008	&#x2718		U+2718
	ALT 10060	274C ALT X	Cross mark	&#10060	&#x274C		U+274C
	ALT 10062	274E ALT X	Negative squared cross mark	&#10062	&#x274E		U+274E
❖	ALT 10070	2756 ALT X	Black diamond minus white X	&#10070	&#x2756		U+2756
⮽	ALT 11197	2BBD ALT X	Ballot box with light X	&#11197	&#x2BBD		U+2BBD
⮾	ALT 11198	2BBE ALT X	Circled X	&#11198	&#x2BBE		U+2BBE
⮿	ALT 11199	2BBF ALT X	Circled bold X	&#11199	&#x2BBF		U+2BBF
	ALT 128499	1F5F3 ALT X	Ballot box with ballot, vote	&#128499	&#x1F5F3		U+1F5F3
🗴	ALT 128500	1F5F4 ALT X	Ballot script X, X mark	&#128500	&#x1F5F4		U+1F5F4
🗵	ALT 128501	1F5F5 ALT X	Ballot box with script X	&#128501	&#x1F5F5		U+1F5F5
🗶	ALT 128502	1F5F6 ALT X	Ballot bold script X	&#128502	&#x1F5F6		U+1F5F6
🗷	ALT 128503	1F5F7 ALT X	Ballot box with bold script X	&#128503	&#x1F5F7		U+1F5F7
🗸	ALT 128504	1F5F8 ALT X	Light check mark	&#128504	&#x1F5F8		U+1F5F8
🗹	ALT 128505	1F5F9 ALT X	Ballot box with bold check	&#128505	&#x1F5F9		U+1F5F9