I know this should be very simple, but I cannot find out how to create an array (string) of names using a list of names in Excel. Attached is the excel file with the names. I am hoping to store the names in an array and then search for each of the names in a text file using the for each loop.
Thanks for the help.LastNames.xlsx (9.4 KB)