software

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 ?

In B1:

=quot;747quot; amp; RIGHT(A1,LEN(A1)-8)

Or if they are 12 digits then

=quot;747quot; amp; RIGHT(A1,4))

HTH

quot;Xaviequot; wrote:

gt; I have some 10,000 number with various digit like 199601013800, 200505010002.
gt; The first 8 digit must be replaced to 747. What formula must be used ?

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. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;Xaviequot; gt; wrote in message
...
gt;I have some 10,000 number with various digit like 199601013800,
gt;200505010002.
gt; The first 8 digit must be replaced to 747. What formula must be used ?