I am writing an Excel Macro and need a little help.
I populate a field with the value of a cell from my spreadsheet.
Serial_Number = Worksheets(1).Cells((i + Caselp), 8).Value
My customer wants me to remove the first 2 characters from the Serial Number.
How do I remove the first 2 characters from my varialbe Serial_Number?
Can you reference each character of a string? In C I can reference the 3rd element of a string by using variable_name. Is there anything similar?