# Solved Excel Copying Part of a Cell to a new cell

May 19, 2009 at 16:04:37
Specs: Windows XP
 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 helpScott

See More: Excel Copying Part of a Cell to a new cell

#1
May 19, 2009 at 16:34:51
✔ Best Answer
 Try this:Cell A1 contains: Exp 2003-2009In cell B1 use the formula: =MID(A1,5,4)you will get 2003In cell C1 use the formula: =RIGHT(A1,4)you will get 2009MIKEhttp://www.skeptic.com/

Report •

#2
May 19, 2009 at 16:42:37
 that worked, thanks for your help

Report •

#3
May 19, 2009 at 16:50:56
 Glad I could help.MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4
May 20, 2009 at 04:54:08
 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.

Report •

#5
May 20, 2009 at 12:17:47
 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 helpScott

Report •

#6
May 20, 2009 at 16:01:10
 ="19"&LEFT(A1,3)&"19"&RIGHT(A1,2)

Report •

#7
May 21, 2009 at 11:04:24
 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))MIKEhttp://www.skeptic.com/

Report •

#8
May 21, 2009 at 11:25:10
 Thanks for the help it worked like a dream!

Report •