View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
se12 se12 is offline
external usenet poster
 
Posts: 1
Default Delete the number "49" from each cell in a column

In a column of numbers, SOME cell of numbers START WITH "23", I need to
delete the first two numbers (23) only and leave the rest of the numbers in
that cell as they appear. A Column can have up to 600 cells. Also, the
numbers are Imported into Excel as TEXT Format. Can you help me...Thank You!!

Example: 231234567890 (Numbers Imported into Excel as TEXT Format)
Need To Look Like This: 1234567890