delete numbers in each cell in same column

  • Thread starter Thread starter Anna Huber
  • Start date Start date
A

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!
 
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
 
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
 
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!
 
Back
Top