LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula too long manman Excel Worksheet Functions 1 September 6th 07 04:20 AM
Clearing cells takes long, long time unclemuffin Excel Discussion (Misc queries) 9 August 17th 07 02:22 AM
Formula too long using IF OR Amanda Excel Worksheet Functions 2 February 27th 07 09:11 PM
formula too long! phil2006 Excel Discussion (Misc queries) 8 July 2nd 06 11:34 PM
Formula too long Neil_J Excel Worksheet Functions 2 March 17th 05 07:11 PM


All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"