« Return the hyperlink
Single List Combobox Filtering »

Replacing text in a cell with more than 1024 characters

27th May 2005, 03:11 am by jkpieterse

If you have ever tried to search and replace in Excel, you may have discovered that this is impossible when a cell contains more than 1024 characters (or will do so after the replacement).

The reason for this, is that in replace mode you can only select “Formulas” to search in:

I have updated my Flexfind utility (build 539) so you can!

Category: General, MVP, Downloads, Add-ins  |  Comment (RSS)  |  Trackback

One Comment

  1. Sige:

    Really Practical, thx a lot!

    29 May 2005, 11:33 pm

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment