Replacing digitnumbers
Would this work?
=REPLACE(A1,1,8,747)
Perhaps add 0 to turn it back into a number:
=REPLACE(A1,1,8,747)+0
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003
"Xavie" wrote in message
...
I have some 10,000 number with various digit like 199601013800,
200505010002.
The first 8 digit must be replaced to 747. What formula must be used ?
|