I am wondering if their is a way to do the working excel faster than write this stuff out cell by cell. What i am doing is, i have a column with a range of years inputed, exp 2003-2009. In the two columns next to it i have to write those two years out, one in each column. 2003, and in the column after it 2009. Is their a macro or formula to do this faster than manulally?

thanks for the help

Scott

Try this: Cell A1 contains: Exp 2003-2009

In cell B1 use the formula: =MID(A1,5,4)

you will get 2003In cell C1 use the formula: =RIGHT(A1,4)

you will get 2009MIKE

that worked, thanks for your help

And, if need be, follow up with a Copy...PasteSpecial...Values to eliminate the formulae and lock in the value. I added a PasteSpecial...Value button to my toolbar since I perform that operation on a regular basis.

I have another question, I got a bunch of data from an auto parts company, now the year is written 94-99, or 99-03. Those are a few examples. I need them written out to the four digit 1994-1999 or 1999-2003. How can these be done?

Thanks again for your help

Scott

="19"&LEFT(A1,3)&"19"&RIGHT(A1,2)

Try this, it will compensate for the year 2000, but will only work up until the year 2030. =IF(LEFT(A1,2)<="30",20&LEFT(A1,2),19&LEFT(A1,2))&" "&IF(RIGHT(A1,2)<="30", 20&RIGHT(A1,2),19&RIGHT(A1,2))

MIKE

Thanks for the help it worked like a dream!

Ask Your Question

Weekly Poll

Do you think Google should sell budget phones in the US?

Discuss in The Lounge

Poll History