Hi All,
I have two columns Names and Email Pattern. Here I need to compare Names with Email Pattern and return the not matching character in the column.
Example:
Names Email Pattern Result
eric Nicole eric_Nicole _
elisabeth rouffiac elisabeth.rouffiac .
ferey Benjamin f.benjamin erey.
philippe motte philippe .motte
Is there any formula or macro to do this?
Bookmarks