Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find/replace [Zx] with [Znumber]
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find/replace [Zx] with [Znumber]
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) "Gary''s Student" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
Find and replace results can the appearance of find be different? | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions |