Splitting Name from Cells to feed back into Multipage Form - More than 2 Strings

The following code is being used to take data that is in a cell, and split it up so that when a user goes to edit the data using a multipage form the "First Name" and "Last Name" fields are populated.

Please Login or Register  to view this content.

I just ran into a situation where somebody had a middle initial listed... so in the Cell it was "Name Middle Last", and when the info was showing in the form it had "Name" in the first name field, and "Middle" in the last name field... because a Strname2 is not being captured - and even if it was the code does not know to put strname2 in the "lastname1" field.

Question that I have is

How would I go about recoding this so that

if "n" is the number of strname() generated, then

Firstname1 = strname(0), strname(1), strname(2)...... strname(n-1) (with spaces in between each name)
Lastname1 = strname(n)

Hi there,

Maybe something like:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

How about

Please Login or Register  to view this content.

Thank you! This worked perfectly.

Originally Posted by mikerickson

How do you want the routine to handle "Jean Claude Van Damme" or "Ludwig Von Beethoven"

I have been torn on that as well.

Luckily the only time that this will be an issue is when somebody's info is being edited... and after the edit is done, it is going to put the full string back into the cell. So in the end, you have Jean Claude Van Damme, splits to Firstname1 = "Jean Claude Van" last name1 = "Damme"

Edits are made in the userform, and when the "Update" button is pushed the cell will again ready "Jean Claude Van Damme" (unless one of the edits was to the name - like a typo or something?)

Originally Posted by snuffnchess

Thank you! This worked perfectly.

You're welcome & thanks for the feedback