Question: I'm new to StackOverflow and to Excel formulas!

I'm trying to replace the word "GIL64000" with the word "GIB64000", I need to do this across many cells A2: H6; A9: G13, etc. 

The cells themselves contain information as follows: "GIL64000\_XX\_X" with "*XX*" varying between *WH*, *BL*,*OR*,*PU*, etc and the"\_X" ranging from L, M, S, XL, XXL (shirt sizes).

So I have cells with values like: "GIL64000\_OR\_S" , "GIL64000\_BL\_XXL" , "GIL64000\_MIN\_M" , "GIL64000\_MIN\_L" etc.

I've tried to get the replace function working by doing this: =REPLACE("GIL64000";3;1; "B")
But it only does this within the cell I have the formula in.

I've tried to add A2: H6 to the formula, but it doesn't accept it and returns with #VALUE! error: =REPLACE(A2:H6;3;1;"B")

I tried some other string like "MID" function, but I can't figure out how to use MID with REPLACE: =REPLACE(MID(A2: H6;3;1; "B"))

I tried to follow some guides and I still can't seem to get it working.

In essence, what I Want is the word "GIL64000" with word "GIB64000" across all my cells and to be able to change the formula as I need it in the future for other values not only "GIL64000"

Answer: 
Because you are not assigning the value of i to anything, or using it in a more complicated expression, --i and i-- will have the same effect.

For example...

Post-increment...

```
int i = 10;
int n = i++; // After this statement, i will be 11 and n will be 10.

```

Pre-increment...

```
int i = 10;
int n = ++i; // After this statement, i will be 11 and n will be 11.

```
In the increment/decrement clause of a for loop post-decrement and pre-decrement operators will result with the same outcome, since the next time the loop's condition is tested, it will see the decremented value either way.

There would be a difference only if the value of `i--` or `--i` is used immediately. 

For example:

```
if (i-- > (n-2))

```

and

```
if (--i > (n-2))

```

will compare different values to `n-2`.