I have a worksheet with cells in column A containing text only. I need to
locate each instance of [Zx] and replace it with [Znumber]. For example: In
cell A1 the first [Zx] substring needs to be replaced with [Z1]. The second
instance of [Zx] needs to be replaced with [Z2]. If there are no more
instances in A1, then moving down to A2, the first instance of [Zx] in A2
needs to be replaced with [Z3], etc.

I only know how to do find/replace with fixed strings.

Thanks in Advance

--
Gary''s Student