How do I delete <br> or <b> that appears in text?

A

AtTheMall-24-7

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?
 
S

Sean

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
 
R

Ron Rosenfeld

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?
Click to expand...

Give some more detail about the "etc" and the nature of the data.

These sorts of things can be processed with Regular Expressions although, if
there are only a few types, you can use Find/Replace


--ron
 
Top