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 Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Find and Replace (?)



 
 
Thread Tools Display Modes
  #1  
Old March 24th, 2010, 07:15 PM posted to microsoft.public.word.docmanagement
Kerns
external usenet poster
 
Posts: 2
Default Find and Replace (?)

I'm actually trying to find and INSERT but I'm not sure how to do it.

For example, I want to find all of the numbers in my document and place a
"$" in front of them.

I am finding them using: ^w^#

but when I replace with: $

it overwrites the first digit.

How do I go about finding and INSERTING?

Thanks.

  #2  
Old March 24th, 2010, 08:11 PM posted to microsoft.public.word.docmanagement
Pesach Shelnitz[_2_]
external usenet poster
 
Posts: 228
Default Find and Replace (?)

Hi,

You can do this with a wildcard search as follows.
1) Press Ctrl+H to open the Find and Replace dialog box.
2) Click More and then select the Use wildcards check box.
3) In the Find what text box, type [0-9]@
4) In the Replace with text box, type $^&
5) Click Find Next and then Replace, or click Replace All.

When you are finished using wildcards, clear the Use wildcards check box and
perform another search to disable wildcards.

For more information on advanced search techniques, see my Web page at
http://www.makeofficework.com/searching.htm.

--
Hope this helps,
Pesach Shelnitz
My Web site: http://makeofficework.com


"Kerns" wrote:

I'm actually trying to find and INSERT but I'm not sure how to do it.

For example, I want to find all of the numbers in my document and place a
"$" in front of them.

I am finding them using: ^w^#

but when I replace with: $

it overwrites the first digit.

How do I go about finding and INSERTING?

Thanks.

  #3  
Old March 25th, 2010, 02:07 PM posted to microsoft.public.word.docmanagement
Kerns
external usenet poster
 
Posts: 2
Default Find and Replace (?)

Thank you for the great information.

Would there happen to be a method to search for a consecutive 'string' of
numbers and place the $ before that string.

In other words, find 12,444.99 and insert a $ before that 'string'. Using
the method that you described puts a $ at: $12,$444.$99.

thanks again,
Kerns
  #4  
Old March 25th, 2010, 02:52 PM posted to microsoft.public.word.docmanagement
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Find and Replace (?)

Search for
([0-9,.]{4,})
replace with
$\1

with the wildcard option set
see http://www.gmayor.com/replace_using_wildcards.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"Kerns" wrote in message
...
Thank you for the great information.

Would there happen to be a method to search for a consecutive 'string' of
numbers and place the $ before that string.

In other words, find 12,444.99 and insert a $ before that 'string'. Using
the method that you described puts a $ at: $12,$444.$99.

thanks again,
Kerns



 




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 05:36 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.