View Single Post
  #21   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 10:36:01 -0700, AFSSkier
wrote:

Ron,
Your UDF code works great, however there are still additional formatting
codes like (hard return), and &

--
Thanks, Kevin


Hit send too fast.

A bit of research reveals that your codes are designated by being between an
"&" and a ";". So we just need to remove those substrings. Again, easily done
with a slight change to the pattern:

re.Pattern = "<[^<]+|[\r\n]|&[^;]+;"

--ron