Thread
:
Replacing digitnumbers
View Single Post
#
1
Posted to microsoft.public.excel.misc
Xavie
Posts: n/a
Replacing digitnumbers
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 ?
Reply With Quote
Replacing digitnumbers