i would like to replace my specific first two-digit number to another number, here a sample REPLACE FORMAT.xlsx
Wouldn't that change number into text by default?How about
Excel Formula:=REPLACE(A2,1,2,6)
yes sirJust checking.. are your first two digits always 60? If not, then you will need to use something like this...
=IF(LEFT(A2,2)="60",0+REPLACE(A2,2,1,""),A2)
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
2 | 60010199562 | 6010199562 | 12020399124 | 3005099781 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2 | B2 | =REPLACE(A2,1,2,6) |
C2 | C2 | =B2*2 |
D2 | D2 | =B2/2 |