Previous Topic Next Topic

Comparing 2 excel with diff length

Closed
sabrinadwitch Posts 6 Registration date Friday July 12, 2013 Status Member Last seen May 1, 2014 - Apr 9, 2014 at 05:09 AM
I have two columns of numbers
A B
123 223Abc
223 334ssd
334 368def
456 456def

i want to compare n match if A is inside B...how?

Final result i want:
A B
123
223 223Abc
334 334ssd
456
Related: