Find and Replace - Limit to Size of Text

  • Thread starter Thread starter Bubbles
  • Start date Start date
B

Bubbles

Hello,
When using Find and Replace I find I can only enter 254 characters into the
FIND WHAT and REPLACE WITH fields (254 each). Is there a way to by-pass this
limitation and enter more text?

Any help would be much appreciated. Thank you.
 
You can Replace with "Contents of the clipboard" (^c). Is there any
limit to the size that can be handled that way?

If you know that your FIND text begins and ends with passages that
won't occur elsewhere, you could use wildcards, with * indicating 'any
number of characters' between the beginning and end of your text.
 
Hello,
When using Find and Replace I find I can only enter 254 characters into the
FIND WHAT and REPLACE WITH fields (254 each).  Is there a way to by-pass this
limitation and enter more text?

Any help would be much appreciated.  Thank you.
Click to expand...

At risk of setting Mr. Daniels' head on fire you can find a VBA method
here:
http://gregmaxey.mvps.org/Find_Long_String.htm

It's a "nails and hammers" method to use his words, but may meet your
needs.
 
Back
Top