If there are names in a list that are similar, like Roosevelt Smith and
Rosette Smith, how could they be concatenated in a third column such
that the first letter that is different in the first name be used in
the combo. For instance, the names would be combined as Rv Smith and
Rt Smith. Note that Rosette only has one "o" whereas Roosevelt has
two, so code that simply counts same letter placements will not work.
So, I have a firstname field and a lastname field, and I want a third
field with the formula. Thanks much for any help ;-)
Arnold