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
|