Wednesday, December 30, 2020

Excel: Split Word Into Separate Cells In Excel

In a blank cell next to your data, C1 for instance, enter this formula:
=MID($A1, COLUMNS($A$1:A$1), 1)

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:

 123456789101112 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 = TrueEnd 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

OneNote Math Operations

Supported arithmetic operators Operator Meaning Example +  (plus sign) Addition 3+3 -  (minus sign) Subtraction Negation 3-1 -1 *  (asteri...