The "story" behind The Excel VBA Handbook Paul Kelly is one of a professional developer realizing that most people were being taught coding the wrong way. The "Light Bulb" Moment
This handbook is for someone who just wants to record a simple sort filter. It is for: the excel vba handbook pdf paul kelly
Sub CleanMessyColumn() Dim rng As Range, cell As Range Set rng = Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row) For Each cell In rng cell.Value = Application.Trim(cell.Value) 'Remove extra spaces If IsNumeric(cell.Value) Then cell.Value = CDbl(cell.Value) Next cell The "story" behind The Excel VBA Handbook Paul