Regex search and wrapping

[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

 

[Peo Sjoblom]

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

 

[Ron Rosenfeld]

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

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