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

in a "helper" column

=IF(LEFT(A1,2)="23",RIGHT(A1,LEN(A1)-2),A1)

Copy down

Copy/past special=values in "helper" column or original

HTH

"se12" wrote:

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