Can i do this with the find and replace function?

Stan De Stoop · External Since: Sep 20, 2009 Posts: 3

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

Graham Mayor · External Since: Jul 04, 2006 Posts: 4676

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

Suzanne S. Barnhill · External Since: Sep 26, 2003 Posts: 24065

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" <gmayor.DeleteThis@REMOVETHISmvps.org> wrote in message
news:ua3BvGeOKHA.220@TK2MSFTNGP02.phx.gbl...
> 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
>
>

Stan De Stoop · External Since: Sep 20, 2009 Posts: 3

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" <gmayor.DeleteThis@REMOVETHISmvps.org> schreef in bericht
news:ua3BvGeOKHA.220@TK2MSFTNGP02.phx.gbl...
> 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
>
>

Stan De Stoop · External Since: Sep 20, 2009 Posts: 3

This works fine,
thanks a lot!

Stan

"Suzanne S. Barnhill" <sbarnhill.DeleteThis@mvps.org> schreef in bericht
news:enrZqueOKHA.5128@TK2MSFTNGP02.phx.gbl...
> 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" <gmayor.DeleteThis@REMOVETHISmvps.org> wrote in message
> news:ua3BvGeOKHA.220@TK2MSFTNGP02.phx.gbl...
>> 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
>>
>>
>

Graham Mayor · External Since: Jul 04, 2006 Posts: 4676

My eyesight is not what it was. I saw the separators between the numbers as
spaces. Sad

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" <gmayor.DeleteThis@REMOVETHISmvps.org> schreef in bericht
> news:ua3BvGeOKHA.220@TK2MSFTNGP02.phx.gbl...
>> 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