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?

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?

On Sat, 1 Apr 2006 17:21:01 -0800, AtTheMall-24-7
wrote:

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?

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