Advanced find and replace - Word XP

[Melissa]

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

 

[Bob I]

Tools, Macro, Record New macro

 

[Melissa]

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.

Tools, Macro, Record New macro

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

 

[Arnold Gao[MSFT]]

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.

 

[Arnold Gao[MSFT]]

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.