Insert a column AFTER Column C in file1 and enter this in the new D1
=SUBSTITUTE(C1," ",", ")
and copy down...

Now in new E1 of file2 enter this
=VLOOKUP(D1,

switch to file1, select column C and D both together
then type
,2,false)
and press enter...

You can copy it down...

You will get #N/A for names not found in file 1..

You can hide that with
=IF(ISNA(Vlookup(),"",Vlookup())

Once you are happy, you can copy everything, paste special as values and
delete either Col C or Col D, as you want.

replace Vlookup() with the Vlookup you got above
"Allen" wrote:

I've got two files of teacher's class information that I need to merge. For
instance, in Column C includes the teachers' names in both files. however,
in FILE1 the names are listed lastname firstname (with no comma) while in
FILE2, the names are listed lastname, firstname (with comma). Of course, the
last names are not the same length from row to row. I need to get the column
D information from File1 and have it show up in Column D in File2. normally,
this would be a simple process of copying and pasting the information except
that there are some names that appear in one file and not both and some
teachers are listed on multiple rows in one file and a different number of
rows in the other file.

Any assistance would be greatly appreciated.