View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NeedHelp! NeedHelp! is offline
external usenet poster
 
Posts: 2
Default Formula Is Too Long

I have an external database that allows me to export to Excel.
When I do so, it also export these html tags into Excel (and there are many).

Some Example Tags:
<p;

<br /

I highlight the column where these tags are at -
I do an Edit Find
In the Find Field I type in the tag: <p
And I Replace with: (this is left blank)
A popup tells me "Formula Is Too Long"


Sometimes it would eliminate the tags from the first few rows, but never the
entire column.
How can I eliminate these multiple tags from the cells?