Replacing using a wildcard

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

Shane Devenshire

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

JLatham

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

Find/Replace MSWord wildcard characters from within Excel 6
"Find" a wildcard as a place marker and "replace" with original va 1
Use of Wildcard characters with replace 2
Wildcard in the Replace function 2
Find and Replace Command Using Wildcard Help 1
Use a wildcard within edit/replace 4
replacing a worksheet 2
how can i change a sequence of numbers using find replace 2

Top