ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Replacing using a wildcard (https://www.excelbanter.com/excel-discussion-misc-queries/236277-replacing-using-wildcard.html)

Arun

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?

Shane Devenshire[_2_]

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?


JLatham

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?



All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com