delete numbers in each cell in same column

[Anna Huber]

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!

 

[Jacob Skaria]

With your data in Col A try the below in B1 and copy down as required

=MID(A1,3,LEN(A1))+0

If this post helps click Yes

 

[Jacob Skaria]

If you have data in cell A1 as 123456789 copy paste the formula in B1 will
return 3456789. Once done you can ........

1. Copy the cell B1 (not the formula). Select the range down. Keeping the
selection Right click>Paste Special>Formulas>OK

OR

2. Select B1. Click the selection handle. Drag as required.

OR

3. Select B1. Copy cell. Select the range down. Press Enter


If this post helps click Yes

 

[Anna Huber]

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]

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