View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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!