Please forgive me as I am still new to VBA and haven't quite figured out everything. I have a set of values (all in column A) that start with "7971" and I want to replace those characters with an "A" (IE: 797100910885 becomes A00910885") in the same column, if possible. If it goes to...
I already have the code for replacing a string with a different string. It works when I know what the contents of the cell are. For example, in this case "A1" contains the string "test".
Dim OriginalText As String
Dim CorrectedText As String