| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
remove and replace a digit...
I am trying to remove a digit and replace it with another digit.
I.E.: A1 has '2001' in the cell... I want to change that to '9001'. I have dabbled with =left (a1,3) to remove the '2' but cannot figure out how to place the 9 in. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove the leading 1 from a nine digit telephone # | Excel Discussion (Misc queries) | |||
| remove and replace digits from a number | Excel Worksheet Functions | |||
| replace last digit in a dollar amount | Excel Discussion (Misc queries) | |||
| How to replace 12 digits only of 16 digit number. | Excel Discussion (Misc queries) | |||
| How to replace the last digit in a cell with a letter | Excel Discussion (Misc queries) | |||
Threaded Mode
