Can i do this with the find and replace function?

S

Stan De Stoop

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
 
G

Graham Mayor

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
S

Suzanne S. Barnhill

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 said:
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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
 
S

Stan De Stoop

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 said:
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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
 
S

Stan De Stoop

This works fine,
thanks a lot!

Stan


Suzanne S. Barnhill said:
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 said:
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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
 
G

Graham Mayor

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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 said:
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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
 

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

Top