Extract First & Second Name into Variable

[Barieq]

Hi,

How can I extract First & Second name into variable. I have the below code which extracts First Name but I need to add the second name to it. If there is only First Name then extract First Name else First and Second.

Please Login or Register  to view this content.

[skywriter]

Please Login or Register  to view this content.

[Barieq]

@skywriter,

Thanks, it's working. Can you please amend to fixed Range("C8")

[skywriter]

Thanks for the rep. points.
I can't fix it without first knowing what's wrong with it and what you expect.
It would be better to upload a workbook with a larger data set, 20 or so examples and what you expect and why.

[Barieq]

Thanks for your support, Nothing wrong in your code, it is working perfect. I have attached the worksheet, In simple sentence code should look for Range("C8") and extract the first and second name instead of Array (bbb, ccc, aaa)

Anyway I have fixed it.

[skywriter]

My array was simply to create three example names as you did not include sample data.
C8 in the sample workbook you attached contains "MAMAS Ports Services Co. Ltd." which does not fit the first name - last name request you originally made, hence my confusion.

[jamesmillere]

Try this-

Please Login or Register  to view this content.

[skywriter]

@jamesmillere
Why are you posting the code I wrote with "try this"?