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
|
|||
|
|||
Advanced find and replace - Word XP
I am using the wildcards feature in find and replace to find the last 6
digits of numbers over 1 million. - [1-9]{6} How would I go about telling the replace field to insert a period in the front of the text, skipping over two numbers, trimm off the rest, insert a space and then the word "million"? For example: Find 1684232 - ([1-9]{6}) Replace with 1.68 million |
#2
|
|||
|
|||
Advanced find and replace - Word XP
Tools, Macro, Record New macro
Melissa wrote: I am using the wildcards feature in find and replace to find the last 6 digits of numbers over 1 million. - [1-9]{6} How would I go about telling the replace field to insert a period in the front of the text, skipping over two numbers, trimm off the rest, insert a space and then the word "million"? For example: Find 1684232 - ([1-9]{6}) Replace with 1.68 million |
#3
|
|||
|
|||
Advanced find and replace - Word XP
I was using the recorder to record this with the find and replace feature,
but it is the replace text I am having trouble with. "Bob I" wrote in message ... Tools, Macro, Record New macro Melissa wrote: I am using the wildcards feature in find and replace to find the last 6 digits of numbers over 1 million. - [1-9]{6} How would I go about telling the replace field to insert a period in the front of the text, skipping over two numbers, trimm off the rest, insert a space and then the word "million"? For example: Find 1684232 - ([1-9]{6}) Replace with 1.68 million |
#4
|
|||
|
|||
Advanced find and replace - Word XP
Hi Melissa,
It seems that we may need to leverage VBA codes to accomplish this goal. Please address the VBA related request in the developer newsgroups. The developer newsgroups are located at: http://msdn.microsoft.com/newsgroups/default.asp. Sincerely, Arnold Gao Microsoft Partner Online Support Get Secure! - www.microsoft.com/security ================================================== == When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== == This posting is provided "AS IS" with no warranties, and confers no rights. |
#5
|
|||
|
|||
Advanced find and replace - Word XP
Hi Melissa,
Just a supplement. I did extensive research on it and found we can do it in this say: Find: ([1-9])([0-9]{2})([0-9]{4}) Replace with: \1.\2 million Hope it helps. Sincerely, Arnold Gao Microsoft Partner Online Support Get Secure! - www.microsoft.com/security ================================================== == When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== == This posting is provided "AS IS" with no warranties, and confers no rights. |
Thread Tools | |
Display Modes | |
|
|