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
|
|||
|
|||
Can i do this with the find and replace function?
Dear members,
I have a big list of telephone numbers in Word 2007 in this form (xx.xx.xx), but i still have to add the zone numbers. They are all similar (056). Now, my question is: How can i add the zone number 056 to all of my telephone numbers at once? I taught i could do it with the find and replace function, but i don't really know how. I hope that somoene can help me, I would be very pleased. Thanks, Stan |
#2
|
|||
|
|||
Can i do this with the find and replace function?
You can search for
[0-9 ]{6,} (note the space after the 9!) replace with 056 ^& with the wildcard option set. If your local list separator character is ; change the find string to [0-9 ]{6;} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Stan De Stoop wrote: Dear members, I have a big list of telephone numbers in Word 2007 in this form (xx.xx.xx), but i still have to add the zone numbers. They are all similar (056). Now, my question is: How can i add the zone number 056 to all of my telephone numbers at once? I taught i could do it with the find and replace function, but i don't really know how. I hope that somoene can help me, I would be very pleased. Thanks, Stan |
#3
|
|||
|
|||
Can i do this with the find and replace function?
Would that wildcard handle the periods between the numbers? Without
wildcards you could equally well search for: ^#^#.^#^#.^#^# and replace with 056 ^& -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Graham Mayor" wrote in message ... You can search for [0-9 ]{6,} (note the space after the 9!) replace with 056 ^& with the wildcard option set. If your local list separator character is ; change the find string to [0-9 ]{6;} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Stan De Stoop wrote: Dear members, I have a big list of telephone numbers in Word 2007 in this form (xx.xx.xx), but i still have to add the zone numbers. They are all similar (056). Now, my question is: How can i add the zone number 056 to all of my telephone numbers at once? I taught i could do it with the find and replace function, but i don't really know how. I hope that somoene can help me, I would be very pleased. Thanks, Stan |
#4
|
|||
|
|||
Can i do this with the find and replace function?
At first, thanks for your reply!
But, if i use [0-9 ]{6.} and 056 ^& in the find and replace function, then word tells that what i've entered, isn't valid. These are some of my telephone numbers without the zone number: 56.42.32 48.35.12 17.97.84 13.65.49 45.68.32 84.31.28 Do you have an idea of what i did wrong? Thanks, Stan "Graham Mayor" schreef in bericht ... You can search for [0-9 ]{6,} (note the space after the 9!) replace with 056 ^& with the wildcard option set. If your local list separator character is ; change the find string to [0-9 ]{6;} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Stan De Stoop wrote: Dear members, I have a big list of telephone numbers in Word 2007 in this form (xx.xx.xx), but i still have to add the zone numbers. They are all similar (056). Now, my question is: How can i add the zone number 056 to all of my telephone numbers at once? I taught i could do it with the find and replace function, but i don't really know how. I hope that somoene can help me, I would be very pleased. Thanks, Stan |
#5
|
|||
|
|||
Can i do this with the find and replace function?
This works fine,
thanks a lot! Stan "Suzanne S. Barnhill" schreef in bericht ... Would that wildcard handle the periods between the numbers? Without wildcards you could equally well search for: ^#^#.^#^#.^#^# and replace with 056 ^& -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Graham Mayor" wrote in message ... You can search for [0-9 ]{6,} (note the space after the 9!) replace with 056 ^& with the wildcard option set. If your local list separator character is ; change the find string to [0-9 ]{6;} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Stan De Stoop wrote: Dear members, I have a big list of telephone numbers in Word 2007 in this form (xx.xx.xx), but i still have to add the zone numbers. They are all similar (056). Now, my question is: How can i add the zone number 056 to all of my telephone numbers at once? I taught i could do it with the find and replace function, but i don't really know how. I hope that somoene can help me, I would be very pleased. Thanks, Stan |
#6
|
|||
|
|||
Can i do this with the find and replace function?
My eyesight is not what it was. I saw the separators between the numbers as
spaces. Change the search pattern to [0-9.]{8} to find the numbers you have listed ^& is the found string so add whatever you need to the start of that eg 056 ^& -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Stan De Stoop wrote: At first, thanks for your reply! But, if i use [0-9 ]{6.} and 056 ^& in the find and replace function, then word tells that what i've entered, isn't valid. These are some of my telephone numbers without the zone number: 56.42.32 48.35.12 17.97.84 13.65.49 45.68.32 84.31.28 Do you have an idea of what i did wrong? Thanks, Stan "Graham Mayor" schreef in bericht ... You can search for [0-9 ]{6,} (note the space after the 9!) replace with 056 ^& with the wildcard option set. If your local list separator character is ; change the find string to [0-9 ]{6;} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Stan De Stoop wrote: Dear members, I have a big list of telephone numbers in Word 2007 in this form (xx.xx.xx), but i still have to add the zone numbers. They are all similar (056). Now, my question is: How can i add the zone number 056 to all of my telephone numbers at once? I taught i could do it with the find and replace function, but i don't really know how. I hope that somoene can help me, I would be very pleased. Thanks, Stan |
Thread Tools | |
Display Modes | |
|
|