Excel VBA : Changing string in cells
- by user1265125
I have cells with data like these:
ABCD123XYZ
MPOP345MLU
.
.
.
.
What I want to do is, to remove the 3rd and 4th character from all these cells, hence giving
AB123XYZ
MP345MLU
How do I do this in VBA?
I have no idea about this language, and if someone can guide me in the right direction, it'd be great :)
I understand I have to:
1. Declare 2 string variables st1 and st2
2. Store data from cell A1 into the variable st1
3. Copy all but the 2nd and 3rd char into str2
4. Output Str2 into B1
5. Move to A2