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 help
Scott

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

Report •


#1
May 19, 2009 at 16:34:51
✔ Best Answer
Try this:

Cell A1 contains: Exp 2003-2009

In cell B1 use the formula: =MID(A1,5,4)
you will get 2003

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

MIKE

http://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.

MIKE

http://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 help
Scott

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))

MIKE

http://www.skeptic.com/


Report •

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

Report •


Ask Question