hmmmmm, well that might be tough, Pat. I have tested it, and this is what I found:
=> nothing works in the find/replace feature in the interface. I tried everything I could think of, including all possible ASCII numbers.
=> when running a check on the cells that are similar to yours, with this code:
it seems as though breaks only come in one form, unless the text inside the cells were pasted in or imported from another formatted program, written in other languages and/or platforms. see these images. looks like you have to use code, I suppose:
https://docs.microsoft.com/en-us/off...p/chr-function
https://docs.microsoft.com/en-us/off...acter-set-0127
https://docs.microsoft.com/en-us/off...ter-set-128255
Bookmarks