Regex search and wrapping

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I'd like to search for text in cells in such a way that I can specify
end-of-word and end-of-cell anchor points in my search expression. Is
there a way to do this?

I'd also like to deactivate wrapping sometimes when searching. Is
there a way to do this?

I can't install anything, but would be interested of knowing such
solutions if there are no solutions native to Excel 2000.

Thanks
 
Nothing built in and since you cannot install anything
you are put of luck.

Of course there are some workarounds like last word delimited by a space etc

--


Regards,


Peo Sjoblom
 
I'd like to search for text in cells in such a way that I can specify
end-of-word and end-of-cell anchor points in my search expression. Is
there a way to do this?

I'd also like to deactivate wrapping sometimes when searching. Is
there a way to do this?

I can't install anything, but would be interested of knowing such
solutions if there are no solutions native to Excel 2000.

Thanks
Click to expand...

Can you use the VBA that comes with Excel?

If so, you can then use the Javascript (ECMA) regex flavor which would allow
you to use the standard end-of-word and end-of-line anchor points. If by
"end-of-cell" you mean the last entry in the cell, that can be specified also.
--ron
 
Back
Top