| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Query
I was wondering if there is a formula to replace the first four digits of any
given sequence of numbers ie 1234567 needs to be replaced with xxxx567.the length of the numbers are varied ie the number could also be 12345 in which case it needs to be replaced with xxxx5. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Query
"davids" wrote in message
... I was wondering if there is a formula to replace the first four digits of any given sequence of numbers ie 1234567 needs to be replaced with xxxx567.the length of the numbers are varied ie the number could also be 12345 in which case it needs to be replaced with xxxx5. ="xxxx"&RIGHT(A1,LEN(A1)-4) -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Get External Data - not editable using Query Wizard | Excel Discussion (Misc queries) | |||
| Formula Help | Excel Worksheet Functions | |||
| Formula Result Won't Query | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Linear Mode
