support searching on Mac OS for unicode characters e.g. 0x000D carriage return
support searching for unicode characters e.g. 0x000D carriage return.
Many data sources use 0x0D for a carriage return.
There are times where it needs to be replaced with something else, like a tab character.
"Carriage return" is often present in imported text.
Also it can be created by Option-Command-Enter (useful in making a list within a cell), or
using the Apple Unicode Hex Input keyboard by holding option and typing the 4 digit hex code Option-000D
When searching for this character in Excel 2011 (or Word 2011) for Mac, Microsoft instead finds the space character.
In the attached file (the green cells), there is carriage returns in cells B2 (several), B6 (by itself) and B16 (between the P and Q). but a search will find the spaces instead. there are cells beside B6 and B16 that show the hex value to confirm it's there.
Your support folks confirmed this behavior on their Mac. Case # 1375519301.
Personally I would consider this a bug, not a feature request.
It also fails to find it when using the "text to columns" feature.
There may be other characters which can't be found, I didn't try others.
I did try searching 0x8D hoping it was a 7bit ascii to 8bit thing, but it didn't work.
searching for the space character 0x0020 works.
In Word, advanced search and replace special character "manual line break" works. or ^|
Found a (not preferred) work around. =SUBSTITUTE(B2,CHAR(13),"%") creates a new cell by replacing decimal 13 (same as 0x0D) with another character (% in this example). The new character can then be used in "text to columns", or search, or search and replace.