View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean
 
Posts: n/a
Default How do I delete <br or <b that appears in text?

Hi,

Sometimes you can search and replace <br with nothing. This can become
tedious if there are lots of variations. Make sure you include and spaces
unless you want these to remain.

Hope this helps.

Sean

"AtTheMall-24-7" wrote in message
...
I downloaded a data file and openned it in Excel. All the columns were
fine
except on text file which had <br, <b, <font, etc throughout the text.
How do I get rid of these tags without having to retype, which is a lot of
data?