A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Office » General Discussions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Advanced find and replace - Word XP



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2004, 08:33 PM
Melissa
external usenet poster
 
Posts: n/a
Default 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  
Old May 5th, 2004, 09:36 PM
Bob I
external usenet poster
 
Posts: n/a
Default 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  
Old May 5th, 2004, 09:41 PM
Melissa
external usenet poster
 
Posts: n/a
Default 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  
Old May 6th, 2004, 12:16 PM
Arnold Gao[MSFT]
external usenet poster
 
Posts: n/a
Default 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  
Old May 10th, 2004, 02:45 PM
Arnold Gao[MSFT]
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.