Comparing 2 Strings and output the difference

[alugo004]

Hi,

I am trying to compare A1 = ABCD to A2 = ABCDEFGHIJKLMNOPQRSTUVWXYZ and out put on A3 the missing letters of A1.

Anyone could help, really appreciated.

Thank You.

[shg]

Perhaps =substitute(a2, a1, "")

[alugo004]

Hi shg,

Thank you for the prompt response, but I need that A3 contains what is in A2 excluding the character that are in A1.

[AlKey]

Please see attached file

[FDibbins]

Hi shg,

Thank you for the prompt response, but I need that A3 contains what is in A2 excluding the character that are in A1.

That is exactly what shg's formula does...
Data Range

	A
1	ABCD
2	ABCDEFGHIJKLMNO
3	EFGHIJKLMNO
4	=SUBSTITUTE(A2,A1,"")

What are you getting?

[alugo004]

Hi FDibbins,

I am getting the following:

A1= ABCD
A2= ABCDEFGHIJKLMNOPQRSTUVWXYZ
A3= ABCDEFGHIJKLMNOPQRSTUVWXYZ
Formula =substitute(A2,A1,"").

[XOR LX]

Hi,

Are you sure your letters in both A1 and A2 are all upper case?

Regards

[alugo004]

Yeah, I made sure all was the same and all formats, but thank you all for the dedicated help.

I was able to use Alkey file, thank you.

Again, thank you all for the help!

[AlKey]

You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

[FDibbins]

I didnt do much, but thanks for the feedback