I STILL NEED HELP!!! -(simple macro in excel prob)
Posted by Lucy Harris on September 26, 2000 7:39 AM
I have a colum of postcodes (5000) and need to run a simple macro to delete all but the first two letters
E.g. DE7 6EF - becomes DE
Davids answer didnt seem to work - but i am a novice , I just deleted a macro I tried to record and wrote in his answer but when I ran it all that happend was the egg timer flashed rapidly, kinda cool but of no use! I would be very greatful if one of you PRO's could help silly ol' me.