LinkBack URL
About LinkBacks
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.
Comparing 2 Strings and output the difference
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.
Perhaps =substitute(a2, a1, "")
Entia non sunt multiplicanda sine necessitate
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.
Please see attached file
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
That is exactly what shg's formula does...Originally Posted by alugo004
Data Range
What are you getting?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi FDibbins,
I am getting the following:
A1= ABCD
A2= ABCDEFGHIJKLMNOPQRSTUVWXYZ
A3= ABCDEFGHIJKLMNOPQRSTUVWXYZ
Formula =substitute(A2,A1,"").
Hi,
Are you sure your letters in both A1 and A2 are all upper case?
Regards
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!
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).
I didnt do much, but thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks