delete spaces between numbers

  • Thread starter antonio bellomi
  • Start date
A

antonio bellomi

I need to delete all spaces between numbers automatically
that is to turn numbers like 34 45 656 to 3445656
how can I do, since the option ^# seems to be valid only for the search
option but not for the replace op.?
tia
 
S

Suzanne S. Barnhill

You can do this with wildcards. With the "Use wildcards" box checked, search
for this:

([0-9])( )

and replace with this:

\1

Note that this will replace every space after every number, not just within
groups of numbers. If the number groups are consistent, you can set up a
wildcard search that will search for the groups and replace them without
spaces. In the example you gave, search for:

([0-9]{2})( )([0-9]{2})( )([0-9]{3})

and replace with:

\1\3\5

For more on using wildcards, see
http://word.mvps.org/FAQs/General/UsingWildcards.htm
 
T

Tony Jollans

That's a bit complex, Suzanne.

Find ([0-9]) ([0-9])
Replace with \1\2
Check Use Wildcards
Hit Replace All

Or if there might be multiple spaces, use Find: ([0-9]) {1,}([0-9])

--
Enjoy,
Tony


Suzanne S. Barnhill said:
You can do this with wildcards. With the "Use wildcards" box checked, search
for this:

([0-9])( )

and replace with this:

\1

Note that this will replace every space after every number, not just within
groups of numbers. If the number groups are consistent, you can set up a
wildcard search that will search for the groups and replace them without
spaces. In the example you gave, search for:

([0-9]{2})( )([0-9]{2})( )([0-9]{3})

and replace with:

\1\3\5

For more on using wildcards, see
http://word.mvps.org/FAQs/General/UsingWildcards.htm



antonio bellomi said:
I need to delete all spaces between numbers automatically
that is to turn numbers like 34 45 656 to 3445656
how can I do, since the option ^# seems to be valid only for the search
option but not for the replace op.?
tia
 
S

Suzanne S. Barnhill

I'm not very strong on wildcards, I'm afraid.



Tony Jollans said:
That's a bit complex, Suzanne.

Find ([0-9]) ([0-9])
Replace with \1\2
Check Use Wildcards
Hit Replace All

Or if there might be multiple spaces, use Find: ([0-9]) {1,}([0-9])

--
Enjoy,
Tony


Suzanne S. Barnhill said:
You can do this with wildcards. With the "Use wildcards" box checked, search
for this:

([0-9])( )

and replace with this:

\1

Note that this will replace every space after every number, not just within
groups of numbers. If the number groups are consistent, you can set up a
wildcard search that will search for the groups and replace them without
spaces. In the example you gave, search for:

([0-9]{2})( )([0-9]{2})( )([0-9]{3})

and replace with:

\1\3\5

For more on using wildcards, see
http://word.mvps.org/FAQs/General/UsingWildcards.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the
newsgroup
so
all may benefit.
 
T

Tony Jollans

No probs! They drive me wild sometimes - they always seem to stop just short
of being _really_ useful.

--
Enjoy,
Tony


Suzanne S. Barnhill said:
I'm not very strong on wildcards, I'm afraid.



Tony Jollans said:
That's a bit complex, Suzanne.

Find ([0-9]) ([0-9])
Replace with \1\2
Check Use Wildcards
Hit Replace All

Or if there might be multiple spaces, use Find: ([0-9]) {1,}([0-9])

--
Enjoy,
Tony


Suzanne S. Barnhill said:
You can do this with wildcards. With the "Use wildcards" box checked, search
for this:

([0-9])( )

and replace with this:

\1

Note that this will replace every space after every number, not just within
groups of numbers. If the number groups are consistent, you can set up a
wildcard search that will search for the groups and replace them without
spaces. In the example you gave, search for:

([0-9]{2})( )([0-9]{2})( )([0-9]{3})

and replace with:

\1\3\5

For more on using wildcards, see
http://word.mvps.org/FAQs/General/UsingWildcards.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the
newsgroup
so
all may benefit.

message
I need to delete all spaces between numbers automatically
that is to turn numbers like 34 45 656 to 3445656
how can I do, since the option ^# seems to be valid only for the search
option but not for the replace op.?
tia
 
A

antonio bellomi

Thank you Suzanne!
You can do this with wildcards. With the "Use wildcards" box checked
search
for this:

([0-9])( )

and replace with this:

\1

Note that this will replace every space after every number, not jus
within
groups of numbers. If the number groups are consistent, you can set u
a
wildcard search that will search for the groups and replace the
without
spaces. In the example you gave, search for:

([0-9]{2})( )([0-9]{2})( )([0-9]{3})

and replace with:

\1\3\5

For more on using wildcards, see
http://word.mvps.org/FAQs/General/UsingWildcards.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to th
newsgroup so
all may benefit.

"antonio bellomi" (e-mail address removed) wrote in
message
I need to delete all spaces between numbers automatically
that is to turn numbers like 34 45 656 to 3445656
how can I do, since the option ^# seems to be valid only for th
search
option but not for the replace op.?
tia
 
A

antonio bellomi

Andf thanks to you too, Tony

Tony said:
That's a bit complex, Suzanne.

Find ([0-9]) ([0-9])
Replace with \1\2
Check Use Wildcards
Hit Replace All

Or if there might be multiple spaces, use Find: ([0-9]) {1,}([0-9])

--
Enjoy,
Tony


"Suzanne S. Barnhill" (e-mail address removed) wrote in message
You can do this with wildcards. With the "Use wildcards" box checked,
search
for this:

([0-9])( )

and replace with this:

\1

Note that this will replace every space after every number, not just
within
groups of numbers. If the number groups are consistent, you can set u
a
wildcard search that will search for the groups and replace the
without
spaces. In the example you gave, search for:

([0-9]{2})( )([0-9]{2})( )([0-9]{3})

and replace with:

\1\3\5

For more on using wildcards, see
http://word.mvps.org/FAQs/General/UsingWildcards.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to th
newsgroup
so
all may benefit.

"antonio bellomi" (e-mail address removed) wrote in
message
I need to delete all spaces between numbers automatically
that is to turn numbers like 34 45 656 to 3445656
how can I do, since the option ^# seems to be valid only for th
search
option but not for the replace op.?
tia
 

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