How to use the RANGE.FIND method
The Range.Find method returns a range object for the first cell that matches the lookup value. Macro used in workbook above The […]

How to use the TEXTTOCOLUMNS method
The TextToColumns method puts a cell that contains a string into substrings and distributes them horizontally using a delimiting character […]