A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can i do this with the find and replace function?



 
 
Thread Tools Display Modes
  #1  
Old September 20th, 2009, 11:53 AM posted to microsoft.public.word.newusers
Stan De Stoop
external usenet poster
 
Posts: 3
Default 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  
Old September 20th, 2009, 12:01 PM posted to microsoft.public.word.newusers
Graham Mayor
external usenet poster
 
Posts: 18,297
Default 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  
Old September 20th, 2009, 01:06 PM posted to microsoft.public.word.newusers
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default 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  
Old September 20th, 2009, 01:11 PM posted to microsoft.public.word.newusers
Stan De Stoop
external usenet poster
 
Posts: 3
Default 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  
Old September 20th, 2009, 01:23 PM posted to microsoft.public.word.newusers
Stan De Stoop
external usenet poster
 
Posts: 3
Default 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  
Old September 20th, 2009, 03:13 PM posted to microsoft.public.word.newusers
Graham Mayor
external usenet poster
 
Posts: 18,297
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:33 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.