| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to replace 12 digits only of 16 digit number.
I need to replace the first twelve digits without effecting the last four of
an account number. Hoping may use the "Find and replace" command without have to replace manually. The repetitive task is as follows in Excel Spreadsheet: Replace 2305-1324-5543-2144 numbers with xxxx-xxxx-xxxx-2144 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop decimal being placed in a 3 digit whole number | Setting up and Configuration of Excel | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| How can i paste a 16 digit number in a excel worksheet? | Excel Discussion (Misc queries) | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| Why is Excel changing the last 2 digits of a 17 digit num to 00. | Excel Discussion (Misc queries) | |||
Threaded Mode
