Thread: With a Function, how can I get rid of formating codes like <div ?
View Single Post
  #27   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default With a Function, how can I get rid of formating codes like <di
On Mon, 1 Jun 2009 18:20:02 -0700, AFSSkier
wrote:

Ron,

You're getting closer. However, the & HTML codes need to be replaced, not
stripped.

&(amper)nbsp = " " (space)
&(amper)amp = & (and)

--
Thanks, Kevin

Kevin,

Also, there are, according to one source, 53 ampersand codes. If you want to
be able to replace all of them, we will need to set up an array, or lookup
table, to do so. Not difficult, just tedious.
--ron
Reply With QuoteReply With Quote