Did you array-enter it?

--

HTH

Bob

"ana" wrote in message
...
No luck, it's showing a 0 when it doesn't match, it also forced a copy of
the
cell that I have the array in, into the one below (really odd).

And I did use the parenthesis w/ the array.

"Bob Phillips" wrote:

Try this array formula

=MIN(IF(NOT(EXACT(MID(F1,ROW(INDIRECT("1:"&LEN(F1) )),1),MID(G1,ROW(INDIRECT("1:"&LEN(G1))),1))),ROW( INDIRECT("1:"&LEN(F1)))))

it will show 0 if the mtach exactly

--

HTH

Bob

"ana" wrote in message
...
I'm currently using the EXACT function to compare two groups of text.

Is there a macro I can write or function I can use where Excel can tell
me,
no it's not an exact match and highlight or format where the text
starts
to
not match.

So it matches up until it gets to the 255th character, and maybe bolds
in
red at the start of non-exact-match.

Please note I'm using Exact b/c the spacing, text, everything within
the
cell must exactly match.


.