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
|