find and replace numbers/letters

1191 · Aug 20, 2008

I want to find and replace something like this "lesson01/0103ap" and
replace with "lesson03/0203xp" and when I try it says can't do numbers...
How do I solve this problem?

Herb Tyson [MVP] · Aug 21, 2008

I think we're going to need some additional information--such as what
program you're using and any special options you might be choosing. In
Microsoft Word, when I put lesson01/0103ap in the Find what: field and
lesson03/0203xp in the Replace with: field, it works just fine. I can't
envision settings that would make Word say it "can't do numbers".

So, if you're getting a message like that, either you're doing something
really unusual, or you're using a different program. Without setting any
options, those also work find for Find/Replace fields in Excel.

1191 · Aug 21, 2008

Herb Tyson [MVP] · Aug 21, 2008

Try pressing Alt+F9 to toggle field code display on. Do the changes that
way, then press Alt+F9 to toggle field results back on. Then press Ctrl+A/F9
to update the fields.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com

1191 · Aug 21, 2008

Where you say Then press Ctrl+A/F9
to update the fields. What is A/F9

Bob I · Aug 21, 2008

It may be more productive for you to ask in the mac.office or
mac.office.word group as this one is primarily Windows office users.

1191 · Aug 21, 2008

Makes sense... will do... but could you please tell me what you mean by A/F9
? The Alt F9 idea did work so show the different views and that in itself
could save time; but I don't know what was meant by the A/F9.. When you said
control + A/F9 does that mean hold down the control and the alt and F9 all
at the same time?

Herb Tyson [MVP] · Aug 21, 2008

I somehow didn't notice that you were on a Mac.

When I said Ctrl+A/F9, I was being brief... that was shorthand for saying
press Ctrl+A (Select All), then press F9 (Update Fields). I have no idea
what the Mac keyboard looks like... so I don't even know if you have a Ctrl
key, an F9 key, or even a key with the letter A on it, for that matter.

If the Mac's version of Word is anything like the Windows version, however,
there should be equivalents that would let you proceed:

Alt+F9 = Toggle between displaying field codes and field results. This will
let your Find/Replace act directly on the contents of hyperlink fields,
rather than merely upon the field results.

Once done, it's necessary to toggle fields again, and then update them. On a
PC, that could be accomplished by pressing Alt+F9, Ctrl+A, F9. I've no clue
how one would do those on a Mac.

1191 · Aug 21, 2008

Thank you so much for the clarification... I will try it and see.
--
1191

Herb Tyson said:
I somehow didn't notice that you were on a Mac.

When I said Ctrl+A/F9, I was being brief... that was shorthand for saying
press Ctrl+A (Select All), then press F9 (Update Fields). I have no idea
what the Mac keyboard looks like... so I don't even know if you have a Ctrl
key, an F9 key, or even a key with the letter A on it, for that matter.

If the Mac's version of Word is anything like the Windows version, however,
there should be equivalents that would let you proceed:

Alt+F9 = Toggle between displaying field codes and field results. This will
let your Find/Replace act directly on the contents of hyperlink fields,
rather than merely upon the field results.

Once done, it's necessary to toggle fields again, and then update them. On a
PC, that could be accomplished by pressing Alt+F9, Ctrl+A, F9. I've no clue
how one would do those on a Mac.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com

1191 · Aug 21, 2008

FYI.... it worked on the Mac the same way. Apparently without pressing the
control -A and F9 after changing the original the link never really changed
... only looked changed on the paper and in the code... is that how it works?
--
1191

Herb Tyson said:
I somehow didn't notice that you were on a Mac.

When I said Ctrl+A/F9, I was being brief... that was shorthand for saying
press Ctrl+A (Select All), then press F9 (Update Fields). I have no idea
what the Mac keyboard looks like... so I don't even know if you have a Ctrl
key, an F9 key, or even a key with the letter A on it, for that matter.

If the Mac's version of Word is anything like the Windows version, however,
there should be equivalents that would let you proceed:

Alt+F9 = Toggle between displaying field codes and field results. This will
let your Find/Replace act directly on the contents of hyperlink fields,
rather than merely upon the field results.

Once done, it's necessary to toggle fields again, and then update them. On a
PC, that could be accomplished by pressing Alt+F9, Ctrl+A, F9. I've no clue
how one would do those on a Mac.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com

Herb Tyson [MVP] · Aug 21, 2008

Right. Some fields automatically update, and some don't. I suspect the lack
of auto-update has something to do with resource conservation.

So... is the bottom line that you now have this sorted out and working? If
so, great!

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com

1191 · Aug 21, 2008

Yes... thanks... for the moment...
--
1191

Herb Tyson said:
Right. Some fields automatically update, and some don't. I suspect the lack
of auto-update has something to do with resource conservation.

So... is the bottom line that you now have this sorted out and working? If
so, great!

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com

1191 · Aug 21, 2008

IS there a way to turn off the hyperlinks in a document period and still have
everything look the same but just not work.... I am talking about a document
that has a long list of URLS that would take too much time to do individually.

Herb Tyson [MVP] · Aug 22, 2008

Sure. Since you're using a Mac, though, I can't be sure how to tell you
where the setting is. In the PC versions, though... Tools - AutoCorrect
Options - AutoFormat As You Type. Remove the check next to Internet and
Network Paths. If you don't do this, then Word will automatically convert
stuff that looks like links into links.

Then, just insert/list your links.

If you want them to look like links but not be links, then color them blue
and underline them.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com

1191 · Aug 22, 2008

THanks you so much. Mac Word has similar tabs.

1191 · Aug 22, 2008

I did what you suggested under Tools .. and the Mac had all the same options
BUT when I went back to my docuent ...after I followed those steps it STILL
opened the links...???? Any suggestions? I tried saving the document and
closing Word and reopening everything and still the links worked..

Herb Tyson [MVP] · Aug 22, 2008

If all you put was the text -- and note completed links -- then Word should
not be converting them into links once you've turned that autoformat option
off.

Are you sure your list is plain text, and not html-laden?

Another thing you try is rather than pasting, use Edit - Paste Special -
Unformatted text. If there is html embedded in the passage you're pasting,
this should strip it out.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com

find and replace numbers/letters

1191

Herb Tyson [MVP]

1191

Herb Tyson [MVP]

1191

Bob I

1191

Herb Tyson [MVP]

1191

1191

Herb Tyson [MVP]

1191

1191

Herb Tyson [MVP]

1191

1191

Herb Tyson [MVP]