Find/replace [Zx] with [Znumber]

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gary''s Student - 24 Jan 2006 16:52 GMT

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

Signature

Gary''s Student

Reply to this Message

Bob Phillips - 24 Jan 2006 17:12 GMT

Gary,

You cannot use Replace which is probably what you are used to, but you need
to use Find and FindNext. Take a look in VBA help for details.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> 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
[quoted text clipped - 9 lines]
> --
> Gary''s Student

Reply to this Message