Monthly Archives: February 2021

Excel (VBA) name-parsing method

Private Sub CommandButton1_Click() ‘ Set rng = Range(“A2”, “A1000”) End Sub Public Sub ParseName(value As String, cel As Range) ‘Given a name string,‘1. Clean it to remove non-valid characters.‘2. Parse it into its consituent parts.‘ Salutation‘ First name‘ Middle name‘ … Continue reading

Posted in Excel, Programming | Leave a comment