![]() |
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? |
All times are GMT +1. The time now is 03:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com