DataQuestioner
Board Regular
- Joined
- Sep 12, 2013
- Messages
- 115
I'm looking for a UDF, Macro or Array that can solve the following challenge >
I have Text in Columns A + B, which could include up to 35,000 Rows.
The Text will be mixed with various forms of punctuation and numerals (see List below of ALL possible "Text" characters).
I want to run a comparison test between the two columns of text and if there are ANY differences between cells A1+B1, A2+B2, etc., all the way down to the final A+B cells in the Columns, then those differences should be populated in Column C - preferably with a space between each difference listed.
EXAMPLE:
If cell A1 contained "This is a test. What is different? Let's find out!"
And cell B1 contained "This is another test, what is different; let's find out!"
Then cell C1 would contain > "another , what ; let's"
The search logic here is that the A Column "Text" is the baseline which is correct, and the B Column contains the deviation.
So in the example above, the B Column contained the new words+punctuation > "another , what ; let's" which when listed in the C Column are each separated by a space.
I hope this makes sense. Thanks in advance.
POSSIBLE "TEXT" CHARACTERS:
0,1,2,3,4,5,6,7,8,9
a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z
!"#$%-&'()*+,¶./:;< =>?@[\]^_`{|}~...
I have Text in Columns A + B, which could include up to 35,000 Rows.
The Text will be mixed with various forms of punctuation and numerals (see List below of ALL possible "Text" characters).
I want to run a comparison test between the two columns of text and if there are ANY differences between cells A1+B1, A2+B2, etc., all the way down to the final A+B cells in the Columns, then those differences should be populated in Column C - preferably with a space between each difference listed.
EXAMPLE:
If cell A1 contained "This is a test. What is different? Let's find out!"
And cell B1 contained "This is another test, what is different; let's find out!"
Then cell C1 would contain > "another , what ; let's"
The search logic here is that the A Column "Text" is the baseline which is correct, and the B Column contains the deviation.
So in the example above, the B Column contained the new words+punctuation > "another , what ; let's" which when listed in the C Column are each separated by a space.
I hope this makes sense. Thanks in advance.
POSSIBLE "TEXT" CHARACTERS:
0,1,2,3,4,5,6,7,8,9
a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z
!"#$%-&'()*+,¶./:;< =>?@[\]^_`{|}~...
