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.
Please Login or Register to view this content.
Last edited by skywriter; 10-28-2023 at 08:48 PM.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
@skywriter,
Thanks, it's working. Can you please amend to fixed Range("C8")
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.
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.
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.
Try this-
Please Login or Register to view this content.
Last edited by AliGW; 10-30-2023 at 07:21 AM. Reason: Code tags corrected.
Thanks
James
@jamesmillere
Why are you posting the code I wrote with "try this"?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks