Find and Replace - Limit to Size of Text

[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.

 

[Peter T. Daniels]

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.

 

[Greg Maxey]

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.

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.

 

[Bubbles]

Thanks everyone....will try these alternatives!

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.
.