Limit to string length in search@replace?

R

Richard Fangnail

There appears to be a limit to how long a search string can be (I
think it's 256 chars). It may also be when using vlookup. I can't
copy and paste a long string into the search field. (Find or
Replace).

what can you do if you are searching for exact strings in a sheet,
that are more than 256 chars?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom toolbar button for search and replace 1
WORD VBA Search and switch to advanced ... 1
Word macro that can call cells out of Excel for a find and replace 0
Prompt For Replace in Selection And More... 0
Can't seem to delete all images from a Word Doc 2
Limit the size of a cell 2
Text string sort limit 1
Insert prefix and suffix to existing string 1

Top