Hello, I am trying to write a macro that will go through each cell in a column with the following format "| 12- 4" or "| 60-11" and will remove the first to character "| ".
There numbers are lengths, the first being feet the second inches. I would like to achieve in a separate column the numerical length (with decimals) multiplied by 1%. My code is as follows I just need help on the conversion.
Sub newLength() Dim LR, lrow As Integer Dim feet, inches, Line As Double LR = Range("B65536").End(xlUp).Offset(1, 0).Row For lrow = LR To 2 Step -1 If Cells(lrow, "D") <> Cells(lrow - 1, "D") Then Rows(lrow).Insert Shift:=xlDown End If feet = Left(Cells(lrow, "E").Value, 4) inches = Right(Cells(lrow, "E").Value, 2) / 12 'I need to debug this line, but I suspect there is more I need to do. Cells(lrow, "F") = feet + inches Next lrow End Sub