Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a formula that delete first character and adds another
I need a formula that deletes and add:
Example: change 127-0112 to X27-0112 delete first character and replace with "X" or replace first character with "X" Tracey Harold |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the formula that identifies v8 in a row & adds v8+v8=v16? | Excel Discussion (Misc queries) | |||
How to set up a formula that it adds value on a certain date | Excel Discussion (Misc queries) | |||
NEED A FORMULA THAT ADDS EVEN OR ODD ROW NUMBERS | Excel Worksheet Functions | |||
Formula which adds together worksheets | Excel Discussion (Misc queries) | |||
Exporting adds a character | Excel Discussion (Misc queries) |