Excel
try this:
=IF(RIGHT(A1,2)="01",LEFT(A1,LEN(A1)-2),A1)
"Puzzled Trainer" wrote:
I have a column of numbers (approximately 100 rows) and wish to remove the
last 2 digits of each one that ends with 01. Is there a way of doing this
please?
Example:
8015601
8025822
8036501
And so on
Thanks
|