Find common text string segments in column

[cft]

I have a column of alpha-numeric strings and need to find what elements are common and located in the same segment of the text string comparing all cells in the column to each other.
In other words cell in row 1 = M0G001EVC07720
cell 2 = M1L001EVC14009
In this case common elements are the leading M and the 001EVC in characters 4-9 within the text strings.
I need to determine what, if any, common string segments exist comparing all of the cells to all others within a column.

 

[FoFa]

your not really giving enough information.
because along with that:
The zero (720) matches the zero's in 4009 (and others)

The one 1 in M1L matches the one in 01EV also.

Would all those be considered matches?

 

[cft]

Thank you. I agree. The purpose for which I need this is to be able to identify any common strings (down to 1 character) that is consistent in any particular section (char 9 alone, or 7-12 together, for example) that are consitent in most/all of the codes. So your point is well taken that a "0" in any place will match a "0" in any other place and that is a match. This is intended to illuminate segments of the codes that are consistent to all or most of the code segments. I hope this is a somewhat better description. Thanks for taking a look at it.