I have a list of text which all end in "Config File", each of these text strings vary in length. I wish to be able to delete the words "Config File" from each of these text strings, and after i have deleted the text then add the text "V2A" to each of the text strings.
Is it possible to do this in VBA, and if so how?
Is it possible to do this in VBA, and if so how?