change first 2 digit ignore the other 2.
Hello Teethless mama
I thankyou.
"Teethless mama" wrote:
=IF(MID(A1,2,1)="0",A1+300,A1)
"Steved" wrote:
Hello from Steved
1010 to 1310 every second digit will change from 0 to 3
1030 to 1330
I would like a formula please to replace the 2 digit only as show'n above
ie 1010 to 1310 not 1010 to 1313
Thankyou.
|