Easy macro problem PLEASE HELP ME!!!!!!!!!!!!!!!!!!
Posted by Lucy Harris on September 26, 2000 5:54 AM
Im having trouble making a macro to run through a huge list of postcodes I have, and delete all but the first two letters of each postcode
eg: DE7 6EF becomes DE
this will be a great help as the list is about 5000 postcodes long, (and you will save my ("student on a work placement") ass!!
Thanks alot!
Posted by David on September 26, 2000 6:24 AM
Sub hello()
y = 1
For x = 1 To 5000
Cells(x, y) = Left(Cells(x, y), 2)
Next x
End Sub
try something to this effect
