If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
find and replace numbers/letters
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? -- 1191 |
#2
|
|||
|
|||
find and replace numbers/letters
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. -- Herb Tyson MS MVP Author of the Word 2007 Bible Blog: http://word2007bible.herbtyson.com Web: http://www.herbtyson.com "1191" wrote in message ... 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? -- 1191 |
#4
|
|||
|
|||
find and replace numbers/letters
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" wrote in message ... I wanted to link a page to show you ... but will try pasting it here instead. Hope it works.. HERE IS WHAT I AM TRYING TO DO… I am using WORD 12.1.2 - Mac I never seemed to have a problem prior to this with find/replace.. I copied the following set of links that work. Then I pasted the copy below the originally copied set. What I wanted to do is to save time from individually typing each one everytime for about 40 chapters but I needed to change the lesson number and file number being used. SO I wanted to do a find and replace… SO what I tried was to highlight a block of sites and then do a find and replace such as find “ lesson01/0103ap” and replace with “lesson05/0302xp”…. And I get the message… Original set that works for what is listed http://www.montereyinstitute.org/cou...1/0103ap_1.swf http://www.montereyinstitute.org/cou...1/0103ap_2.swf http://www.montereyinstitute.org/cou...1/0103ap_3.swf http://www.montereyinstitute.org/cou...1/0103ap_4.swf http://www.montereyinstitute.org/cou...1/0103ap_5.swf http://www.montereyinstitute.org/cou...2/0202xp_1.swf http://www.montereyinstitute.org/cou...2/0202xp_2.swf http://www.montereyinstitute.org/cou...2/0202xp_3.swf http://www.montereyinstitute.org/cou...2/0202xp_4.swf http://www.montereyinstitute.org/cou...2/0202xp_5.swf http://www.montereyinstitute.org/cou...3/0203ap_1.swf http://www.montereyinstitute.org/cou...3/0203ap_2.swf http://www.montereyinstitute.org/cou...3/0203ap_3.swf http://www.montereyinstitute.org/cou...3/0203ap_4.swf SECOND SET I PASTED TO DO A FIND AND REPLACE ON - FIRST I HIGHLIGHT THE SECTION THEN I TRY THE FIND/REPLACE LOOK BELOW TO SEE THAT THIS TIME IT DID FIND AND REPLACE BUT IT LEFT THE ORIGINAL LINK !!!! AS I am writing this I am trying it again and FOR A MINUTE I THOUGHT IT WAS WORKING… At least I am getting farther than I was and the letters and numbers area replacing themselves ( for some reason this was not happening before..) however the link remains the same as the original SO HOW DO I GET IT TO REPLACE IT REALLY IN THE LINK WITHOUT DOING EACH ONE LETTER BY LETTER IN THE INSERT HYPERLINK FORM? ALSO IS THERE A WAY I CAN TURN OFF THE HYPERLINK CAPABILITY ALL TOGETHER SO THAT I CAN NOT HAVE IT UNINTENTIONALLY GOING TO THE SITE.. ALBIET THE SAME ORIGINAL SITE… PERHAPS IF I CAN DO IT ALL JUST IN TEXT THEN GO TURN IT INTO LINKS.. SO HOW DO I KEEP IT FROM BEING A LINK UNTIL I TELL IT TO? What I eventually want to do is to change what is displayed to the example below showing the chapter title, etc. Looking for any and all suggestions you may have to assist me.. http://www.montereyinstitute.org/cou...5/0302xp_1.swf http://www.montereyinstitute.org/cou...5/0302xp_2.swf http://www.montereyinstitute.org/cou...5/0302xp_3.swf http://www.montereyinstitute.org/cou...5/0302xp_4.swf http://www.montereyinstitute.org/cou...5/0302xp_5.swf http://www.montereyinstitute.org/cou...6/0303ap_1.swf http://www.montereyinstitute.org/cou...6/0303ap_2.swf http://www.montereyinstitute.org/cou...6/0303ap_3.swf http://www.montereyinstitute.org/cou...6/0303ap_4.swf http://www.montereyinstitute.org/cou...6/0303ap_5.swf http://www.montereyinstitute.org/cou...7/0402xp_1.swf http://www.montereyinstitute.org/cou...7/0402xp_2.swf http://www.montereyinstitute.org/cou...7/0402xp_3.swf http://www.montereyinstitute.org/cou...7/0402xp_4.swf http://www.montereyinstitute.org/cou...7/0402xp_5.swf http://www.montereyinstitute.org/cou...8/0403xp_1.swf http://www.montereyinstitute.org/cou...8/0403xp_2.swf http://www.montereyinstitute.org/cou...8/0403xp_3.swf http://www.montereyinstitute.org/cou...8/0403xp_4.swf http://www.montereyinstitute.org/cou...8/0403xp_5.swf http://www.montereyinstitute.org/cou...9/0502ap_1.swf http://www.montereyinstitute.org/cou...9/0502ap_2.swf http://www.montereyinstitute.org/cou...9/0502ap_3.swf http://www.montereyinstitute.org/cou...9/0502ap_4.swf http://www.montereyinstitute.org/cou...9/0502ap_5.swf VL http://www.montereyinstitute.org/cou...9/0902vl_1.swf Unit 4 http://www.montereyinstitute.org/cou...0/0602xp_1.swf http://www.montereyinstitute.org/cou...0/0602xp_2.swf http://www.montereyinstitute.org/cou...0/0602xp_3.swf http://www.montereyinstitute.org/cou...0/0602xp_4.swf http://www.montereyinstitute.org/cou...0/0602xp_5.swf http://www.montereyinstitute.org/cou...1/0604ap_1.swf http://www.montereyinstitute.org/cou...1/0604ap_2.swf http://www.montereyinstitute.org/cou...1/0604ap_3.swf http://www.montereyinstitute.org/cou...1/0604ap_4.swf Unit 3 The Gene Lesson 12 Topic 1 Overview http://www.montereyinstitute.org/cou...2/0702ap_2.swf http://www.montereyinstitute.org/cou...2/0702ap_3.swf http://www.montereyinstitute.org/cou...2/0702ap_4.swf http://www.montereyinstitute.org/cou...2/0702ap_5.swf http://www.montereyinstitute.org/cou...2/0702ap_6.swf THIS WOULD HAVE BEEN THE NEXT SET I WOULD DO A FIND/REPLACE ON… But upon trying the links out I find that only what is displayed changed..not the link.. Since I have to do this for almost 70 lessons each with about 5 sections I am trying to find a faster way to do it… HELP! http://www.montereyinstitute.org/cou...2/0202xp_1.swf http://www.montereyinstitute.org/cou...2/0202xp_2.swf http://www.montereyinstitute.org/cou...2/0202xp_3.swf http://www.montereyinstitute.org/cou...2/0202xp_4.swf http://www.montereyinstitute.org/cou...2/0202xp_5.swf -- 1191 "Herb Tyson [MVP]" wrote: 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. -- Herb Tyson MS MVP Author of the Word 2007 Bible Blog: http://word2007bible.herbtyson.com Web: http://www.herbtyson.com "1191" wrote in message ... 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? -- 1191 |
#5
|
|||
|
|||
find and replace numbers/letters
Where you say Then press Ctrl+A/F9
to update the fields. What is A/F9 -- 1191 "Herb Tyson [MVP]" wrote: 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" wrote in message ... I wanted to link a page to show you ... but will try pasting it here instead. Hope it works.. HERE IS WHAT I AM TRYING TO DO… I am using WORD 12.1.2 - Mac I never seemed to have a problem prior to this with find/replace.. I copied the following set of links that work. Then I pasted the copy below the originally copied set. What I wanted to do is to save time from individually typing each one everytime for about 40 chapters but I needed to change the lesson number and file number being used. SO I wanted to do a find and replace… SO what I tried was to highlight a block of sites and then do a find and replace such as find “ lesson01/0103ap” and replace with “lesson05/0302xp”…. And I get the message… Original set that works for what is listed http://www.montereyinstitute.org/cou...1/0103ap_1.swf http://www.montereyinstitute.org/cou...1/0103ap_2.swf http://www.montereyinstitute.org/cou...1/0103ap_3.swf http://www.montereyinstitute.org/cou...1/0103ap_4.swf http://www.montereyinstitute.org/cou...1/0103ap_5.swf http://www.montereyinstitute.org/cou...2/0202xp_1.swf http://www.montereyinstitute.org/cou...2/0202xp_2.swf http://www.montereyinstitute.org/cou...2/0202xp_3.swf http://www.montereyinstitute.org/cou...2/0202xp_4.swf http://www.montereyinstitute.org/cou...2/0202xp_5.swf http://www.montereyinstitute.org/cou...3/0203ap_1.swf http://www.montereyinstitute.org/cou...3/0203ap_2.swf http://www.montereyinstitute.org/cou...3/0203ap_3.swf http://www.montereyinstitute.org/cou...3/0203ap_4.swf SECOND SET I PASTED TO DO A FIND AND REPLACE ON - FIRST I HIGHLIGHT THE SECTION THEN I TRY THE FIND/REPLACE LOOK BELOW TO SEE THAT THIS TIME IT DID FIND AND REPLACE BUT IT LEFT THE ORIGINAL LINK !!!! AS I am writing this I am trying it again and FOR A MINUTE I THOUGHT IT WAS WORKING… At least I am getting farther than I was and the letters and numbers area replacing themselves ( for some reason this was not happening before..) however the link remains the same as the original SO HOW DO I GET IT TO REPLACE IT REALLY IN THE LINK WITHOUT DOING EACH ONE LETTER BY LETTER IN THE INSERT HYPERLINK FORM? ALSO IS THERE A WAY I CAN TURN OFF THE HYPERLINK CAPABILITY ALL TOGETHER SO THAT I CAN NOT HAVE IT UNINTENTIONALLY GOING TO THE SITE.. ALBIET THE SAME ORIGINAL SITE… PERHAPS IF I CAN DO IT ALL JUST IN TEXT THEN GO TURN IT INTO LINKS.. SO HOW DO I KEEP IT FROM BEING A LINK UNTIL I TELL IT TO? What I eventually want to do is to change what is displayed to the example below showing the chapter title, etc. Looking for any and all suggestions you may have to assist me.. http://www.montereyinstitute.org/cou...5/0302xp_1.swf http://www.montereyinstitute.org/cou...5/0302xp_2.swf http://www.montereyinstitute.org/cou...5/0302xp_3.swf http://www.montereyinstitute.org/cou...5/0302xp_4.swf http://www.montereyinstitute.org/cou...5/0302xp_5.swf http://www.montereyinstitute.org/cou...6/0303ap_1.swf http://www.montereyinstitute.org/cou...6/0303ap_2.swf http://www.montereyinstitute.org/cou...6/0303ap_3.swf http://www.montereyinstitute.org/cou...6/0303ap_4.swf http://www.montereyinstitute.org/cou...6/0303ap_5.swf http://www.montereyinstitute.org/cou...7/0402xp_1.swf http://www.montereyinstitute.org/cou...7/0402xp_2.swf http://www.montereyinstitute.org/cou...7/0402xp_3.swf http://www.montereyinstitute.org/cou...7/0402xp_4.swf http://www.montereyinstitute.org/cou...7/0402xp_5.swf http://www.montereyinstitute.org/cou...8/0403xp_1.swf http://www.montereyinstitute.org/cou...8/0403xp_2.swf http://www.montereyinstitute.org/cou...8/0403xp_3.swf http://www.montereyinstitute.org/cou...8/0403xp_4.swf http://www.montereyinstitute.org/cou...8/0403xp_5.swf http://www.montereyinstitute.org/cou...9/0502ap_1.swf http://www.montereyinstitute.org/cou...9/0502ap_2.swf http://www.montereyinstitute.org/cou...9/0502ap_3.swf http://www.montereyinstitute.org/cou...9/0502ap_4.swf http://www.montereyinstitute.org/cou...9/0502ap_5.swf VL http://www.montereyinstitute.org/cou...9/0902vl_1.swf Unit 4 http://www.montereyinstitute.org/cou...0/0602xp_1.swf http://www.montereyinstitute.org/cou...0/0602xp_2.swf http://www.montereyinstitute.org/cou...0/0602xp_3.swf http://www.montereyinstitute.org/cou...0/0602xp_4.swf http://www.montereyinstitute.org/cou...0/0602xp_5.swf http://www.montereyinstitute.org/cou...1/0604ap_1.swf http://www.montereyinstitute.org/cou...1/0604ap_2.swf http://www.montereyinstitute.org/cou...1/0604ap_3.swf http://www.montereyinstitute.org/cou...1/0604ap_4.swf Unit 3 The Gene Lesson 12 Topic 1 Overview http://www.montereyinstitute.org/cou...2/0702ap_2.swf http://www.montereyinstitute.org/cou...2/0702ap_3.swf http://www.montereyinstitute.org/cou...2/0702ap_4.swf http://www.montereyinstitute.org/cou...2/0702ap_5.swf http://www.montereyinstitute.org/cou...2/0702ap_6.swf THIS WOULD HAVE BEEN THE NEXT SET I WOULD DO A FIND/REPLACE ON… But upon trying the links out I find that only what is displayed changed..not the link.. Since I have to do this for almost 70 lessons each with about 5 sections I am trying to find a faster way to do it… HELP! http://www.montereyinstitute.org/cou...2/0202xp_1.swf http://www.montereyinstitute.org/cou...2/0202xp_2.swf http://www.montereyinstitute.org/cou...2/0202xp_3.swf http://www.montereyinstitute.org/cou...2/0202xp_4.swf http://www.montereyinstitute.org/cou...2/0202xp_5.swf -- 1191 "Herb Tyson [MVP]" wrote: 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. -- Herb Tyson MS MVP Author of the Word 2007 Bible Blog: http://word2007bible.herbtyson.com Web: http://www.herbtyson.com "1191" wrote in message ... 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? -- 1191 |
#6
|
|||
|
|||
find and replace numbers/letters
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 wrote: Where you say Then press Ctrl+A/F9 to update the fields. What is A/F9 |
#7
|
|||
|
|||
find and replace numbers/letters
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? -- 1191 "Bob I" wrote: 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 wrote: Where you say Then press Ctrl+A/F9 to update the fields. What is A/F9 |
#8
|
|||
|
|||
find and replace numbers/letters
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" wrote in message ... 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? -- 1191 "Bob I" wrote: 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 wrote: Where you say Then press Ctrl+A/F9 to update the fields. What is A/F9 |
#9
|
|||
|
|||
find and replace numbers/letters
Thank you so much for the clarification... I will try it and see.
-- 1191 "Herb Tyson [MVP]" wrote: 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" wrote in message ... 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? -- 1191 "Bob I" wrote: 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 wrote: Where you say Then press Ctrl+A/F9 to update the fields. What is A/F9 |
#10
|
|||
|
|||
find and replace numbers/letters
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 [MVP]" wrote: 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" wrote in message ... 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? -- 1191 "Bob I" wrote: 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 wrote: Where you say Then press Ctrl+A/F9 to update the fields. What is A/F9 |
|
Thread Tools | |
Display Modes | |
|
|