Search & Replace Text with a symbol

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there

I'm hoping you giys may be able to assist. I have a table in excel, which
I've brought over to frontpage.

It has scores for the week in a sports competition.

There is a column that indicates whether a person has moved up or down from
the previous week / month.

I would like to replace the "-" or "+" with a symbol i.e. an arrow pointing
up (wingdings 3: 112) or down (wingdings 3: 113) , as is appropriate.

I would love a macro in FP2003 to be able to do that!? Any ideas??

Thanks for any help!



Eddie

PS: I have had a little success, and have created a macro that replaces the
"-" & "+" with corresponding letters in the default font, but I'm not able to
convert them to wingdings 3!!
 
Open your code view. Click ctrl-H and replace every instance of "+" with

<font face="Wingdings 3">Ç

Then replace every instance of "-" with the same code, substituting 200 for
199. Don't omit the semicolon after the 199 and 200.

BUT those better be the only pluses or minuses on the page ;-)

PS: IMHO text arrows look cleaner. Try replacing the "+" with &uarr; and
the "-" with &darr; No need to specify the font unless you're into fancy
faces.
 
thanks thor, for the time to help out!

i agree re the text arrows - they do look better - i've gone with them!
however, when i do a search and replace with a macro, it automatically
converts the "↓" to "&darr;" for some reason!

i can do it manually by search and replace, but it seems to me that it would
be that much easier to do with a macro! i.e. click one button and away it
goes! i'm just not clever enough to be able to do it!

thanks again though for your help!



mike
 
Back
Top