I need a macro!!!
Posted on 2003-11-03
how can I write a macro either in Excell 2000 or VB to do the following work for me:
XXXXXX will change to XXXX, BB, XX
AAAAAA will change to AAAA BB AA
I mean that I have a very big file that has about two thousand lines and each line has six characters (letters and
I need tochange them inthis way:
First the first four characters then a camma then BB then
camma then the last two charachters of the same line.
this must be done more than 2000 times !!!!
and some times I need to do it just in half an hour !!!
I must say that the original file is text file, but can be opened
with Excell, word, ....
thanks in advance.