I'm trying to use this formula:
REPLACE("S";1;1;"O")
To remove the first instance of S only. An example of what the column would look like:
<tbody>
</tbody>
Sadly, It is necessary that I drag the formula I have down thus resulting in all the "S" being replaced by "O".
REPLACE("S";1;1;"O")
To remove the first instance of S only. An example of what the column would look like:
T |
O |
O |
P |
P |
T |
S |
S |
P |
O |
T |
O |
O |
<tbody>
</tbody>
Sadly, It is necessary that I drag the formula I have down thus resulting in all the "S" being replaced by "O".
Last edited: