Replacing using a wildcard

  • Thread starter Thread starter Arun
  • Start date Start date
A

Arun

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?
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use of Wildcard characters with replace 2
Wildcard in the Replace function 2
"Find" a wildcard as a place marker and "replace" with original va 1
Use a wildcard within edit/replace 4
Replace with wildcards 2
Excel Wildcard in Excel array formula 0
Find and Replace Command Using Wildcard Help 1
Why not accept wildcards for REPLACE as well as FIND ? 5

Back
Top