Search MrExcel

I STILL NEED HELP!!! -(simple macro in excel prob)

I have a colum of postcodes (5000) and need to run a simple macro to delete all but the first two lettersE.g. DE7 6EF - becomes DEDavids 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.Thanks alotLucy **

It can also be done without a macro :-1.Let's say your data is in column A.2.Insert a column to the right of column A.3.Enter the following formula in the first cell of this new column :-=LEFT(A1,2)4.Fill the formula down as far as required.5.Delete column A.

Celia

Posted by Loren on September 26, 2000 9:06 AM

-(simple macro in excel prob)

Do Not Delete col. A until you have convertedyour formulas to hard numbers.

Posted by Celia on September 26, 2000 9:09 AM

Re: -(simple macro in excel prob)

Quite right! Thanks Loren

Posted by ori yovel on October 30, 2000 7:34 AM

universal macro

hi,i would like to know how can imake the same macro work fordifferent excel files?thanks,ori

(12 responses) HI! I am using a vlookup/match to populate fields from column headers. For the most part it's doing exactly what I need except instead of pu

Let's Connect

MrExcel.com debuted on November 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on this
web site are provided "as is" and we do not guarantee that they can be used in all
situations.
This site contains affiliate links. Any affiliate commissions that we
earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com
running. You can earn a commission for sales leads that you send to us by joining our
affiliate program.
View our Privacy Policy, Cookies Policy, and Terms of Use.