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

Toppers I used your solution and IT WORKED LIKE A CHARM.....THANK YOU SO MUCH!
!!!

Toppers wrote:
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

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

[quoted text clipped - 3 lines]
Example: 231234567890 (Numbers Imported into Excel as TEXT Format)
Need To Look Like This: 1234567890