Hello,
I'm looking for a way (excel formula) to compare two text strings and return what's in common between the two.
All the information is in one column so i will apply the formula in the column next to it and copy the formula down to the other rows.
<colgroup><col width="237" style="width:178pt"> </colgroup><tbody>
</tbody>
I'm looking for a way (excel formula) to compare two text strings and return what's in common between the two.
All the information is in one column so i will apply the formula in the column next to it and copy the formula down to the other rows.
M T |
M T W |
T W H The answer is T Any help would be appreciated |
<colgroup><col width="237" style="width:178pt"> </colgroup><tbody>
</tbody>