delete numbers in each cell in same column
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
"Anna Huber" wrote:
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!
|