Replacing using a wildcard
 

I have a large data sheet with formula referencing cells on 'WorkSheet' row
35. I would to change them all to reference the same column number on row
36. (ie change all references to U35 to U36, change all references to B35 to
B36)

I tried doing this using find/replace using a wildcard as follows:
Find: WorkSheet!?35
Replace: WorkSheet!?36

Doesn't work. Can I use the wildcard this way such that it finds a
character but leaves it unaltered during the replace?

Replacing using a wildcard
 

Hi,

You can't use wildcard in the find command so select the range and do a
Replace by changing 35 to 36. 35 in the Find what box, 36 in the Replace
with box.

If this won't work you may need to tell us more.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Arun" wrote:

I have a large data sheet with formula referencing cells on 'WorkSheet' row
35. I would to change them all to reference the same column number on row
36. (ie change all references to U35 to U36, change all references to B35 to
B36)

I tried doing this using find/replace using a wildcard as follows:
Find: WorkSheet!?35
Replace: WorkSheet!?36

Doesn't work. Can I use the wildcard this way such that it finds a
character but leaves it unaltered during the replace?

Replacing using a wildcard
 

Attack it in 2 stages instead of trying to get there in one step.

Replace Worksheet!U35 with Worksheet!U36
and then
Replace Worksheet!B35 with Worksheet!B36

either one first, your choice.


"Arun" wrote:

I have a large data sheet with formula referencing cells on 'WorkSheet' row
35. I would to change them all to reference the same column number on row
36. (ie change all references to U35 to U36, change all references to B35 to
B36)

I tried doing this using find/replace using a wildcard as follows:
Find: WorkSheet!?35
Replace: WorkSheet!?36

Doesn't work. Can I use the wildcard this way such that it finds a
character but leaves it unaltered during the replace?