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
|
|||
|
|||
delete spaces between numbers
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 -- antonio bellomi |
#2
|
|||
|
|||
delete spaces between numbers
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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "antonio bellomi" 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 the search option but not for the replace op.? tia -- antonio bellomi |
#3
|
|||
|
|||
delete spaces between numbers
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" 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 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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "antonio bellomi" 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 the search option but not for the replace op.? tia -- antonio bellomi |
#4
|
|||
|
|||
delete spaces between numbers
I'm not very strong on wildcards, I'm afraid.
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Tony Jollans" No Mail wrote in message ... 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" 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 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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "antonio bellomi" 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 the search option but not for the replace op.? tia -- antonio bellomi |
#5
|
|||
|
|||
delete spaces between numbers
No probs! They drive me wild sometimes - they always seem to stop just short
of being _really_ useful. -- Enjoy, Tony "Suzanne S. Barnhill" wrote in message ... I'm not very strong on wildcards, I'm afraid. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Tony Jollans" No Mail wrote in message ... 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" 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 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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "antonio bellomi" 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 the search option but not for the replace op.? tia -- antonio bellomi |
#6
|
|||
|
|||
delete spaces between numbers
Thank you Suzanne! Suzanne S. Barnhill Wrote: 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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "antonio bellomi" 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 the search option but not for the replace op.? tia -- antonio bellomi -- antonio bellomi |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delete duplicate numbers | Noemi | General Discussion | 4 | September 23rd, 2005 02:00 AM |
How can I DELETE a CONTACT from the Contacts Folder without an Err | Frustrated & Fuming in Fairview | Contacts | 1 | July 5th, 2005 08:52 PM |
How to delete spaces in a Field? | Bob | Running & Setting Up Queries | 2 | February 4th, 2005 05:46 PM |
Can't delete contact folders with the delete key or | aperson | Contacts | 0 | December 2nd, 2004 12:10 AM |
Extracting spaces from a string of numbers | johnnyrad | Worksheet Functions | 5 | February 4th, 2004 04:34 PM |