I think the copy down has been explained to you. For my macro

If you're new to macros, you may want to read David McRitchie's intro
at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Anna Huber" wrote in message
...
Thank you for the quickk response. I need this in lay men's terms to
understand...step by step. If you are able to do so, I would greatly
appreciate it!

"Don Guillett" wrote:

You could use a formula=RIGHT(A6,LEN(A6)-2) and copy down in a helper
column.
OR
sub droptwo()
mc="a" 'column A
for i=1 to cells(rows.count,mc).end(xlup).row
cells(i,mc).value=right(cells(i,mc),len(cells(i,mc )-2)
next i
end sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Anna Huber" <Anna Huber @discussions.microsoft.com wrote in message
...
Is there an easy way to just delete the first two numbers in each cell
all
the way down the column? i.e. 123456789 to 3456789? Would I have to
create
a helper column; put in a formula for the removal of the first two
numbers
then cut and paste on the column I want to adjust? If so, can you tell
me
specifically how to do this and why I am this specific formula to
achieve
this action....... Thank you!