Return full name based on a specific first name

[Ak97]

Hi Everyone

I am trying to extract the full name based on certain first names from a huge database. I loaded an excel file which contains all of the names which I need as the first name. I want to use a function which returns the rest of the name if the name is present in the excel file which I load. Is there any function or any way that I could do this? 

Below is the script if anyone is curious.

LOAD

INSURED_NAME,
INSURED_TYPE,
NATIONAL_ID,
MT_DRIVER_GENDER,
CATEGORY,
SEGMENT_CODE,
BRANCHES,
ISSUE_DATE
    
FROM [C:\Users\moath\Desktop\ACTUARIAL_27B_MTR.qvd](qvd);

LOAD INSURED_NAME,
     Count
FROM
[C:\Users\moath\Desktop\Test.xlsx]
(ooxml, embedded labels, table is Sheet1);

[edwin]

yes, there are multiple ways of doing this.  imo using left was most readable.