View Single Post
  #7   Report Post  
Merrill Mitler Merrill Mitler is offline
Junior Member
 
Posts: 0
Post

Quote:
Originally Posted by Graham Mayor View Post
If you want to read the background, 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




Yandros wrote:
Hi Graham,

Thank you very much. This definitely hits the spot. You've saved me a
great deal of time (can you imagine having to do this manually on a
series which contains some 1800 to 2000 values)!

I am very grateful. Thank again for taking the time and effort (and
also finding the solution so quickly too).

"Graham Mayor" wrote:

Use a wildcard replace of
([0-9]{1,})#
with
\1 (with format font red colour & bold set)

--

Graham Mayor - Word MVP

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




Yandros wrote:
Hi all,

Can anyone provide me with guidance.

I have a series of comma & space separated values in the format:-

542224452, 5422245#, 54222740, 54223425, 5422346, 542235, 54224140,
54224141#, 542244412, 542244413#, 542244414#, 542244415#,
542244416#, 542244417#, 542244418#.

I'd like use a find and replace function to find all the numbers
ending in a # and replace them with just the number (ie without the
#) but in bold (or another colour ie Red).

Any advice will be gratefully received.

Thanks in advance

Yandros
Hello,

This is a related question: How can one search for the following string: "^p, followed by any 3 characters, followed by a space" and replace ONLY the space with a ^t?

I have not been able to use wildcards or other special search characters.

Thanks,
Merrill