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.

```
The semantics of the operators is as follows

* `--i` evaluates to `(i-1)` and then sets `i=i-1`
* `i--` evaluates to `i` and then sets `i=i-1`

The only difference is in what the expression evaluates to. They both effectively set `i` to a new value. And the next time `i` is referenced the new value will be seen. 

In order to see the difference between the two variants you have to make use of the value the expression evaluates to. 

For example:

* `int x = i--`
* `int x = --i`
* `myArray[i--]`
* `myArray[--i]`

In the above examples `x` will have different values and a different element will be referenced in `myArray`.