Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing digitnumbers
In B1:
="747" & RIGHT(A1,LEN(A1)-8) Or if they are 12 digits then ="747" & RIGHT(A1,4)) HTH "Xavie" wrote: 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 ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replacing #N/A values with zero values | Excel Worksheet Functions | |||
Stopping autoformat when replacing cells. | New Users to Excel | |||
XL 2003: Replacing X-Axis Labels with Custom Ones... | Charts and Charting in Excel | |||
Replacing text in Excel files on disk? | Excel Discussion (Misc queries) | |||
Filtering and replacing values through a macro | Excel Worksheet Functions |