View Single Post
  #3   Report Post  
jessi
 
Posts: n/a
Default

you can use a macro like this one (which only converts
one number)

Selection.Find.ClearFormatting
With Selection.Find
.Text = "#"
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = True
End With
Selection.Find.Execute
Selection.MoveLeft Unit:=wdWord, Count:=2,
Extend:=wdExtend
Selection.Font.Bold = wdToggle
Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
-----Original Message-----
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

.