Re: create simple macro


Yes, the second post was a mistake.

I have 6 columns with information.
the second column has an id number with 2 letters and 5 numbers (ie:
ccxxxxx). example: cc14081.
I would like to make this id number bigger by adding 2 numbers in a
specific place in the id number (ie: ccxxxx05x). example: cc1408051.

I took the column of numbers and placed it in a new work*** in column
a

i took the formula =LEFT(A1,6)&"05"&RIGHT(A1,1) and placed it in column
b.

I then copied it down and It worked. Thank you.

can I recap what was done.

LEFT(A1,6) in cell A1 go from the left 6 spaces
&"05"& insert 05
RIGHT(A1,1) in cell A1 go from the right 1 space and leave the digit in
place.

Is this correct?

Is it possible to make this so that you can actually take the number
out and replace it. as long as the column was identified?

thanks,
Ron


--
noraisens
------------------------------------------------------------------------
noraisens's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31450
View this thread: http://www.excelforum.com/showthread.php?threadid=511382

.