software

I downloaded a data file and openned it in Excel. All the columns were fine
except on text file which had lt;brgt;, lt;bgt;, lt;fontgt;, 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 lt;brgt; 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

quot;AtTheMall-24-7quot; gt; wrote in message
news
gt;I downloaded a data file and openned it in Excel. All the columns were
gt;fine
gt; except on text file which had lt;brgt;, lt;bgt;, lt;fontgt;, etc throughout the text.
gt; How do I get rid of these tags without having to retype, which is a lot of
gt; data?
On Sat, 1 Apr 2006 17:21:01 -0800, AtTheMall-24-7
gt; wrote:

gt;I downloaded a data file and openned it in Excel. All the columns were fine
gt;except on text file which had lt;brgt;, lt;bgt;, lt;fontgt;, etc throughout the text.
gt;How do I get rid of these tags without having to retype, which is a lot of
gt;data?

Give some more detail about the quot;etcquot; 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