| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Substitute ,replace and delete in a cell.
Can anyone help me with a formula ?
From the example cell contents below,i need to substitute the first letter(A) with G,delete the the third number (0),and delete the last three numbers(000) All the cells containing my data are in exactly the same sequence,so the formula would be the same for all. AB02030000 Thanks in anticipation. Doug |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete cell that doesn't contain a specific word | Excel Discussion (Misc queries) | |||
| Delete cell contents with input to adjacent cell | Excel Discussion (Misc queries) | |||
| can't delete a cell content in excel | New Users to Excel | |||
| How do you delete a cell then shift cell up? | Excel Discussion (Misc queries) | |||
| Delete Cell Value Based on Another Cell T or F | Excel Discussion (Misc queries) | |||
Threaded Mode
