Apple to Apple Comparison and Highlighting the Mismatch Character

[Ayyam Raj V]

I need a excel function to compare the cell text and highlight the mismatches characters.

Example:

A1 cell has the value: Apple
B1 cell has the value: Apple1

I need that output as "Apple1" that "1" needs to be highlighted.

 

[GraH - Guido]

Might be possible with Power Query if you need to compare B to A (not the opposite) it's like this.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Set_types = Table.TransformColumnTypes(Source,{{"Lemma", type text}, {"Compare", type text}}),
    Diff = Table.AddColumn(Set_types, "Difference", each
                  Text.Combine(
                       List.Difference(
                             Text.ToList([Compare])
                           , Text.ToList([Lemma]))
                        ,  " , ")
            )
in
    Diff

 

[Ayyam Raj V]

Thank you GraH - Guido! It's very Useful.

 

[GraH - Guido]

Most welcome, Ayyam. Glad to help.

Edit: I missed it was a thread on the VBA sub-forum. If you need that, be patient for others to reply.

 

[vletm]

Ayyam Raj V​

Didn't You this in Ask an Excel Question-forum in the beginning?
Here one sample with VBA ...
You can change that color as You would like ...